Creating a form for a relational database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been making a relational database in access and am now tring to make
the form.
I am trying to make one form that I will be able to put all the information
needed into and will put it into the tables. I have made a form with subforms
but when ever I try to switch between sections I get an error message saying
"You cannot add or change a record because a related record is required in
table "(other table name here)"

Is there any way I can creat a form that will allow me to make a form that
will allow me to add data into all 3 tables.
 
The record source for the form(s) is most likely a query. Change the record
source to the table that you want each of the forms to feed and your problem
should go away. Make sure that you have good Parent/Child links between the
forms.
 
Back
Top