Help with textbox

[CJ_London]

see attached db which I have quickly put together

recipeDB.zip

[Gregm66]

Yes I changed menu type to MenuID.
Checked it is the primary key now.
Dlookup was used on my textbox named RCPMethod.
After update.
Not sure where I'm going wrong it comes up with #Name.
The code I used is.

=dlookup ("RCPMethod","tblRecipes","MenuID=" & Me.Combo9)

[Gregm66]

Thanks for the sample that you posted for me to look at Ajax I will look over what you have done and try to discover where I have gone wrong.
Thankyou for all your help so far it is muchly appreciated.

[Gregm66]

Hi Ajax.
It was a combination of things my table wasn't right. I had removed the auto number field I guess it needed that.
And my control sources were messed up. Thanks for your help.
How easy would it be to enter the data to the form then have a save button to save it to the table.

[CJ_London]

How easy would it be to enter the data to the form then have a save button to save it to the table.

very easy - at the bottom of the form, on the navigation bar, click on the > icon just to the left of the filter icon - this will take you to a new record where you can copy and paste to each field. Data will be saved automatically when you leave the record or close the form.

There are other ways of course, create a button which does the same as the > icon. Or a button that changes the form mode to data entry (and another to change it back)