S
shesgone
What should be simple has me stumped. I have a main database form,
'frmJobs' open, the key field being 'ISSPropNo'. I then open a second
form, 'frmFind' based on a query which filters for different values in
the Jobs table, 'tblJobs'. The 'frmFind' form displays the key field
value of the selected record in a textbox control, 'chrISSPropNo'.
Several other values are also displayed to allow the user to confirm
that the correct record has been selected.
What I want to do is then close the second form and have the first form
move to the selected record. At this point I simply close the second
form via the close window (X box). It seems that I need to first set
the focus in the second form to the 'chrISSPropNo' field; get the value
of 'chrIssPropNo' into a variable, close form two; then find the record
in 'frmJobs' where 'ISSPropNo' equals the variable value. If someone
could give me the specific VBA code statements in the proper events to
do this I would be sooo.. greatful.
'frmJobs' open, the key field being 'ISSPropNo'. I then open a second
form, 'frmFind' based on a query which filters for different values in
the Jobs table, 'tblJobs'. The 'frmFind' form displays the key field
value of the selected record in a textbox control, 'chrISSPropNo'.
Several other values are also displayed to allow the user to confirm
that the correct record has been selected.
What I want to do is then close the second form and have the first form
move to the selected record. At this point I simply close the second
form via the close window (X box). It seems that I need to first set
the focus in the second form to the 'chrISSPropNo' field; get the value
of 'chrIssPropNo' into a variable, close form two; then find the record
in 'frmJobs' where 'ISSPropNo' equals the variable value. If someone
could give me the specific VBA code statements in the proper events to
do this I would be sooo.. greatful.