Creating A Data Access Page

I am trying to make a DAP for data input into a table.

I used the wizard and it has the fields I want, I can scroll through them and view the entries, but they are not editable.

I read about changing the Page DataEntry property to True, but I still cannot select any of the editboxes on the DAP and now the DAP just shows blank non-selectable editboxes.

I decided to create a dummy table to work with to test creating a DAP, my dummy table looks like this:

Group Name Number Text
1 Bill 3 pink
1 Adam 5 green
2 Charlie 7 blue

I ran the wizard on the above table and again I can scroll through but not select any of the fields, and with DataEntry set to True I still cannot select/edit the textboxes.

Is there something else I need to do to be able to make an input form?


Once I get that sorted out I have a followup question: The dummy table above is where the input data goes, but on the input form I would like if possible to get the Group and Name from a different table using drop-lists. The real table has over 5000 names split into groups of about 30-50 so picking a group first would help find a name in the list which will eventually be input to the table above.

Hope that all makes sense, and thanks in advance for any help!