Refresh records - deperate!

  • Thread starter Thread starter Sue B.
  • Start date Start date
S

Sue B.

Hello everyone!

Thank you in advance for your help. I'm linking a form to
another form with an ID number. The user clicks the button
that says "Next Page" and the other form should open up
and display the matching record.

The ID is generated in SQL server and doesn't show up
until the form is closed/re-opened or I hit the
Records/Refresh menu option. Can this action be coded?

I can link on the key, which is two fields, text and
number, but don't know how to code it with different data
types.

The refresh problem is always there with SQL Server
identity fields or calculated fields. It would be soooo
nice to have a solution. Please help!
 
The save record worked in this case, but in the case of a
calculated field, only records/refresh or close/reopen
form. Does anyone know of a docmd or keystrokes to do the
records/refresh?
 
Back
Top