inconsistent updates and the consequences

G

Guest

I have a form based on a query which when the employeeID is entered, the
forename and surname are displayed. However, I have had to make some changes
which included adding a new table which, in turn, made the query not
updateable. I have solved this by changing the properties to dynaset -
inconsistant updates, but in doing so I now cannot get the fields to display
the forename and surname with the input of the employeeID. If I close the
query (or form based on this query) then reopen it, the information is
displayed.
Does this make logical sense? Is there a way I can get round this problem as
I want to display the info on the form.
 
L

Linda Burnside

Try creating an event on Update with the following line between the subs:

Me.Requery

Linda
 

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

Dynaset, inconsistent updates 20
Changing the search field 2
Dates Subquery 1
Setting text in bold 3
Display parameter used for query 2
Problem editing a query based on another query and table 3
Query non-updateable when composite key field used. 1
Data entry denied in a query. 6

Top