Using popup form to add data to main form.

[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.

 

[Graham R Seach]

Henry,

See if this helps:
http://www.pacificdb.com.au/MVP/Code/MyDialog.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[M G Henry]

Henry,

See if this helps:
http://www.pacificdb.com.au/MVP/Code/MyDialog.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia








- Show quoted text -

Graham,

How would this differ if all I had on the popup form was a single
bound text box plus a command button that closed the popup that would
capture the value instead of Combo boxes.

M G Henry

 

[Graham R Seach]

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