Using popup form to add data to main form.

  • Thread starter Thread starter M G Henry
  • Start date Start date
M

M G Henry

I have two tables, one is tblJobnum which has a single field Job# that
is a primary key
the other table is tblmain that has a field also called job# ( it is
on the many side of a one to many relationship)

I have developed a form frmmain that populates the table tblmain, but
would like to use a popup form with the single field Job# from
tblJobnum as there will be instances in which this popup form will be
used to add a new unique job number, and there will be instances in
which the form is used just to add rows in tblmain for pre existing
job numbers.

I have the two forms created, and the one does work as a popup from
the other, I just cannot seem to link them so that entering the job#
field on the popup form, also populates the job# field that is in
tblmain.

I think I am making a very basic error somewhere along the lines that
is keeping the popup field from populating the field on the frmmain
form.
 
Henry,

It doesn't matter what controls you have on the dialog, the technique is the
same.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Two Tables Using One Form Contents 0
Connecting popup forms to parent forms 4
Removing choices from combobox query but stilling showing for older entries 5
Add multiple values on table based on listbox 0
Pop-up form that creates record that links 1:1 to main form 0
How to refresh a table after updating the main form from popup form? 1
Transfer Data between forms 1
odd subform which is on the one side of a one to many relationship 6

Back
Top