G
Guest
I am designing a form (Access2003) that is opened from another form based on
the selection criteria from a combo box (ex. Clinical Evaluation, Service
Authorization, etc.)
Once the user selects the form type from the combo box and clicks the Select
button, the Event Procedure appends pertinent client info (ID#, name, DOB,
etc.) to the appropriate table and opens the appropriate form. This event
procedure appears to work fine. The selected form opens fine with the the
client info displayed, but once the user adds other data to the form, the
data appears in the form but when selecting the command button that triggers
a macro to open the report, there is no data displayed other than the client
info that was appended to the table earlier and there is also no data in the
underlying table.
Once the form is closed and then reopened, the data that was entered but did
not display initially is there. Why is the data entered on the form not
captured in the fields in the underlying table? The form is using the table
as its record source. Any suggestions?
the selection criteria from a combo box (ex. Clinical Evaluation, Service
Authorization, etc.)
Once the user selects the form type from the combo box and clicks the Select
button, the Event Procedure appends pertinent client info (ID#, name, DOB,
etc.) to the appropriate table and opens the appropriate form. This event
procedure appears to work fine. The selected form opens fine with the the
client info displayed, but once the user adds other data to the form, the
data appears in the form but when selecting the command button that triggers
a macro to open the report, there is no data displayed other than the client
info that was appended to the table earlier and there is also no data in the
underlying table.
Once the form is closed and then reopened, the data that was entered but did
not display initially is there. Why is the data entered on the form not
captured in the fields in the underlying table? The form is using the table
as its record source. Any suggestions?