T
tuesamlarry
Need to enter data into a pop up form which has a common field with the main
form. Not using subform design in this instance because I already have
numerous Tabs, subforms, etc. and screen real estate is limited. Main form ID
is [srvcServiceTicketID] and the pop up form has [utilUtilityVoucherTicket]
which are the linking fields between the two tables. I want to call the pop
up, and have the 'ID' field automatically populated so I can then enter the
data in the pop up. I tried a query using the [utilUtilityVoucherTicket]
field criteria as [Forms]![sfrmServiceProvided]![srvcServiceTicketID], but it
didn't work.
Do I need VBA to SetFocus and then set a value to [utilUtilityVoucherTicket]?
Does the underlying query need to have the 'ID' fields from each table?
form. Not using subform design in this instance because I already have
numerous Tabs, subforms, etc. and screen real estate is limited. Main form ID
is [srvcServiceTicketID] and the pop up form has [utilUtilityVoucherTicket]
which are the linking fields between the two tables. I want to call the pop
up, and have the 'ID' field automatically populated so I can then enter the
data in the pop up. I tried a query using the [utilUtilityVoucherTicket]
field criteria as [Forms]![sfrmServiceProvided]![srvcServiceTicketID], but it
didn't work.
Do I need VBA to SetFocus and then set a value to [utilUtilityVoucherTicket]?
Does the underlying query need to have the 'ID' fields from each table?