I am a complete newbie to Access and mostly self taught and am struggling with one particular problem.
I have created a database that the prime page is a membership database with member personal details – name, address date of birth etc.
These members are regularly invited to functions and having selected the correct member from the main Members form a click opens the Acceptance form. This form records the function applied for, the menu choice, etc
The member name is automatically applied to the Acceptance form but it is necessary to select the function from a combo box fin a pop up form the Functions table.
As there will be many members accepting for the same function I am trying to get the function name to be applied to the field in this form automatically, unless changed by the operator.
I have tried to do this by getting the field to default to the data recorded for the last (i.e. previous) record and as far as I can ascertain I should use the DMax and DLookup functions but I’m not sure how to! Presumably this would be some code on the Form as a On Open event?.....or am I misunderstanding this completely
Any guidance would be much appreciated.