Link to home
Start Free TrialLog in
Avatar of EASCOA
EASCOA

asked on

Access 2007 Database

Database consist of a form with a couple of tabbed subforms.  The main form has the primary key and date which is displayed and entered at the very top of the form.  Is there a way to not allow the user to input anything in the subform/body until the primary key field has been autopopulated.   This was prompted due to testing...where the entire form was populated with data, but the PK field never populated and resulted in a unbound record.  Thanks in advance for your help.
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Are you using an auto number or a custom PK field?
Avatar of EASCOA
EASCOA

ASKER

I guess it might be a custom PK--the department to identify their records...the primary key is set to start with "ST "000000000
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial