Hello everyone,
Could anybody advise me on how to auto populate a field in a sub form?
The main form just has the ID number and name
and the sub form has five fields.
'Form Name' 'Date on form' ' Patient ID' 'Form complete' 'Notes'
The first field 'form name' will have about 60 records of individual form names (from another table) and what I want to do is to set up the form so that when the info is entered into the main form,
the 'form name' field auto populates so that the date and complete fields can be updated at a later time.
I hope this makes some sense, Im a beginner and I imagine its quite simple but it is starting to drive me crazy
Any help or advice would be appreciated
Many thanks , Anna
Could anybody advise me on how to auto populate a field in a sub form?
The main form just has the ID number and name
and the sub form has five fields.
'Form Name' 'Date on form' ' Patient ID' 'Form complete' 'Notes'
The first field 'form name' will have about 60 records of individual form names (from another table) and what I want to do is to set up the form so that when the info is entered into the main form,
the 'form name' field auto populates so that the date and complete fields can be updated at a later time.
I hope this makes some sense, Im a beginner and I imagine its quite simple but it is starting to drive me crazy

Any help or advice would be appreciated
Many thanks , Anna