add table to form afterwards ?

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

Guest

hello, my name is johan and i have a question:
after i made a form, i discovered that i still have to add a new table to my
form.
when i use the wizzard when i create a new form i can add as much tables as
i want, but when the form has already been made i don't know how to add these
tables to my form. is there a simple way to do this ( i guess there is !), or
do i have to start all over again ?
greetings and many thanks, johan
 
Hi, Johan.

If you haven't already invested much labor in customizing it, you're better
off simply recreating it. But if you're doing it manually, the answer
depends on the relationship between the table on which the main form is based
and this new table. If you need to change it manually, post the nature of
your existing and new tables.

Just so you're aware, when you "base" a form on a particular table, the
wizard sets the form's RecordSource property to this name. For detail
tables, it creates a continuous form and then inserts the form onto the main
form, where it becomes a subform control. The control has two key
properties, LinkMasterFields and LinkChildFields, which specify the
relationship between the recordsources of the main and subforms, respectively.

Hope that helps.
Sprinks
 
Back
Top