Hello.
I have a macro that runs a select query to pull back all group data from an outside database. The next step is a find unmatched query using the data pulled back from the select query against a table I want the data appended to. Next step, append the data retrieved with the find unmatched query. This is all working fine.
Here is where the problem starts. I have a form that is used to fill in the missing data on the records that were just appended. From there, another form is used to keep track of dates, etc. From this form, there is a button that runs a Make Table query, using the Group Number field on the form as criteria. If the form is displaying a Group Number of a record that was manually entered into the database, it creates the table with no problem. If the form is displaying the Group Number of an appended record, I get a blank table.
I have deleted the group number data in the table that was appended to and reentered the data manually. I have searched the forum, I have called my help desk. I'm beating my head against the wall at this point.
I have a macro that runs a select query to pull back all group data from an outside database. The next step is a find unmatched query using the data pulled back from the select query against a table I want the data appended to. Next step, append the data retrieved with the find unmatched query. This is all working fine.
Here is where the problem starts. I have a form that is used to fill in the missing data on the records that were just appended. From there, another form is used to keep track of dates, etc. From this form, there is a button that runs a Make Table query, using the Group Number field on the form as criteria. If the form is displaying a Group Number of a record that was manually entered into the database, it creates the table with no problem. If the form is displaying the Group Number of an appended record, I get a blank table.
I have deleted the group number data in the table that was appended to and reentered the data manually. I have searched the forum, I have called my help desk. I'm beating my head against the wall at this point.
