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
 
Ad

Advertisements

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.
 
Ad

Advertisements


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

Top