refresh form when data changes

[AC-Dev]

Hello all,

I have a form that is directly connected to a table. The form is used to search and gets populated with two values (table_name, _number_of_records). Basically, when the user searches in this form, i search the entire database for relevant data and return what table and how many records meet the search criteria.

Basically what i want to do is refresh the table after the search is complete instead of having to close and reopen the table.

I have tried me.refresh and me.requery and even this code i found online:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

still, all it says is #deleted on both fields when i search.

any suggestions?

 

[Guus2005]

Apparently you have deleted the data you are viewing. Otherwise you shouldn't see #DELETED.

I need to see your code to get a better understanding of what is happening.
Can you post a sample database describing the problem?

HTH

 

[AC-Dev]

Apparently you have deleted the data you are viewing. Otherwise you shouldn't see #DELETED.

I need to see your code to get a better understanding of what is happening.
Can you post a sample database describing the problem?

HTH

yes the data does get deleted. On search_Click() the data in the search table (which holds the table name and amount of 'hits' for whatever table gets returned) gets cleared and repopulated based on the new criteria. i would just like the form to represent those changes when the data in the table is changed.

 

[AC-Dev]

got it.

i did docmd.requery

for some reason it didnt open before