simple macro for a form

G

Guest

I have text box which shows a list of employee names to choose in the form.
Near this I have a little edit label. On click, the edit button opens a query
datasheet where I can modify employee names. Once I close this query , the
updates are not reflected in the employee names text box right away.Can you
please tell me how to achieve this.
here is the macro I used.
txtemployeename: on click Open Query
Requery

The control name is employeeID (textbox) for the requery.
Thanks a lot
accessfremont
 
A

AccessVandal via AccessMonster.com

Hi,

Try "RepaintObject" after the "Requery". Select "Object Type = Form" and
select "Object Name = the name of your form"

Hope it works for you. You should post this in the "Macros Forum".
PS. If it does not work you might need to refresh the form by a command
button or create another macro to refresh the form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GoTo a record from a combo in the form 4
Data Entry Form. 3
Query Results in Text Box 4
How to use a combo box in a bound form? 3
'Go to Record' button - simple task but can't get it to work 1
Form With Combo Boxes 4
Access 2007 Form with macros that apply filter 3
query form 3

Top