Refresh records - deperate!

[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!

 

[blm]

try
docmd.sav
doevent


hth blm

 

[Guest]

Thanks again!

 

[Guest]

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?

 

[smk2]

Me.requer
or

Me.refres

HTH
SMK

 

[Brandon]

Sue

This line will work

Me.refres
o
me.requer

 

[Guest]

I mean computed column, not calculated field. Sorry.

 

[Sue]

Thanks, Brandon!