User Friendly Data Entry

[LaFred84]

Please Exuse the question I am about to ask. I am a bit rusty with Access and cant remember how to do the following. I have tried and tried to work it out and tried various help searches but cant get the answer I'm looking for.

What I need to do is create a data entry form, very simple! However I want the user to be prompted to enter a project name and number in order to find the project that i want the new data to be entered under. Then it will need to create a new record in that project ready for new data to be entered from the data entry form.

I hope it is clear what I need to do

 

[quiksilver1804]

Well if the data entry form is based off of a table, turn it into a query. Drop down all the fields (individually, double clicking the title will highlight all fields, then just pull them all down). In the "Criteria" section put:

[Enter Project Name] in the Criteria: for the project name field

[Enter Project ID] in the Criteria: for the project number field.

Hope this gets you started on what you need. Note, this will be an exact match only. You might want to put "Like [Enter Project Name]*" to do a wildcard search. I'm not sure if that is the correct syntax for that but play with it and you should get it..

good luck!