Prefill Records in Form

  • Thread starter Thread starter Stalin
  • Start date Start date
S

Stalin

I have a table with the 3 columns attached to a form

1 - Experience

2 - Yes/No

3 - Role

I want to prefill the experience column with 15 entries for the user
to complete when they open the form.

Is there a way to do this in Access?
 
Joe,
Are you saying you want to provide the user with 15 choices from which to
opick one to go in Experience?
If so, create a table with the 15 choices and then place a combobox based on
that table in the form with Experience as the record source.
 
Joe,
Are you saying you want to provide the user with 15 choices from which to
opick one to go in Experience?
If so, create a table with the 15 choices and then place a combobox based on
that table in the form with Experience as the record source.
Click to expand...

My intention is to have on form open is to create 15 records with the
experience Column filled in,
EXPERIENCE YES/NO ROLE
ROW 1 - Biologics
ROW 2 - Small Molecule
ROW 3 - Drug Delivery
ROW 4 - BioAnalytical

so on so that the user is presented with 15 rows

the user then would only have to complete the YES/NO and Role which
would be combo boxes with their values based on a query.
 
My intention is to have on form open is to create 15 records with the
experience Column filled in,
EXPERIENCE YES/NO ROLE
ROW 1 - Biologics
ROW 2 - Small Molecule
ROW 3 - Drug Delivery
ROW 4 - BioAnalytical

so on so that the user is presented with 15 rows

the user then would only have to complete the YES/NO and Role which
would be combo boxes with their values based on a query.
Click to expand...

I am going to use an Append Query, don't know why I didnt think of
that before.

Thanks for your help and quick response

Stalin
 
Back
Top