Update a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have a firls there by click runs a query
works fine
But the field have now a new value in the table
how do i get the field to update this so i can see it in my form

regards
Alvin
 
alvin said:
Hi
I have a firls there by click runs a query
works fine
But the field have now a new value in the table
how do i get the field to update this so i can see it in my form

regards
Alvin
Click to expand...

I think that you need to add this line of code in VB after your query runs:

me.yourform.requery

that should refresh your form and show the records that were added or the
edits that were made to any records.
 
You must log in or register to reply here.

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

field value from another table 1
Creating Checkbox Fields For Every Record 0
Update a combobox 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Update a form 1
Not All Fields Update my Table from my Form 5
Access How to remove a non-existent field from a form's Field List 0
Running an Update query before closing a form 2

Back
Top