subform not functioning when main form opened by macro

R

ryan_eng

Hi all,

I have created a form and subform that work great when the main form is
opened by itself. However, now I have another form which acts as a "gateway"
if you will to this main form, where the user inputs 2 pieces of key info and
a macro sends the info to the related fields in the main form. When I execute
the macro (button on the gateway form), everything works fine. The data is
transfered, the form is opened and everything seems good. However, the
subform does not seem to be working. When data is entered into the subform I
get the message "You cannot add or change a record because a related record
is required in table 'tbl_Time_Tracking'"
I'm assuming I need to add something to the macro that properly opens the
subform or something along those lines. Help is appreciated!

Ryan
 
Top