When to refresh?

[tweetyksc]

I have a user form that is used basically to import data into tables, roll data up to a ytd table, etc.

There is also a command button to open a table directly to do editing/deleting of records, etc. Next to each table name/option button I have a disabled textbox with a dlookup that counts the number of records in the underlying table.

With the cmds for import/rollup I have been able to easily refresh the count data with "me.refresh" by including this at the end of the subs.

Is there anyplace I can put this to run the refresh after they have used the cmd button to open a table? In other words, they have chosen their desired table, clicked the edit button, opened the table, deleted a record, and closed the table. I assume I am now out of the sub, so cannot put it there.

I know I can put a "refresh" button on the form, but was looking to see if there was maybe a "behind the scenes" way of doing it, when the table is closed.

 

[Vassago]

I assume the user is able to edit the data directly on the table. What you could do is make a form for them to edit, add, or delete data instead, then place the code in the onclose event of the form.

There isn't any way to add this code to the table that I know of.

Good Luck!

Vassago

 

[tweetyksc]

Vassago/Pat--I had a feeling I would need to create a form. What I'm doing is taking a database someone else created and doing a user interface and automating things.

Pat - refresh is what I need. I'm trying to refresh the dlookup textbox which simply shows a COUNT of how many records are in the underlying table.

This works fine (me.refresh) after the code is run for the import (for the user to confirm there are records) and the rollup (to confirm there are now zero records) commands, and works fine with a 'refresh' button; I was simply trying to find a way to do it automatically when the table is closed.

I'm going to create a datasheet view form and then be able to control it. Trying to take the lazy way out doesn't work, does it??

 

[Vassago]

Access doesn't know the meaning. Comes up with variable not defined.