Update code not linking form and table, WHY!!!

[Guest_imported]

When entering data in the field [STRIP REPLATE]![GRIT] of form [SEND OUT FOR REPLATE] I get a pop-up form asking for SEND OUT FOR PLATE!Strip Replate!Grit . Upon entering data or selecting ok a second pop-up form asks for SEND OUT FOR PLATE!Strip Replate!FBM ID. If I enter data in these pop-ups the fields our updated in WHLINVTY table. Does anyone know why the update is not recognizing or linking the fields with the form?
This is the Update code I’m using.
DoCmd.RunSQL ("UPDATE WHLINVTY SET [WHLINVTY].[GRIT] = [SEND OUT FOR REPLATE]![Strip Replate]![GRIT] WHERE [SEND OUT FOR REPLATE]![Strip Replate]![FBM ID]=[WHLINVTY].[FBM ID]&quot

 

[huzza]

Hi Larry,
try changing your code from

DoCmd.RunSQL ("UPDATE WHLINVTY SET [WHLINVTY].[GRIT] = [SEND OUT FOR REPLATE]![Strip Replate]![GRIT] WHERE [SEND OUT FOR REPLATE]![Strip Replate]![FBM ID]=[WHLINVTY].[FBM ID]")

to

DoCmd.RunSQL ("UPDATE WHLINVTY SET [WHLINVTY].[GRIT] = [forms]![SEND OUT FOR REPLATE]![Strip Replate]![GRIT] WHERE [forms]![SEND OUT FOR REPLATE]![Strip Replate]![FBM ID]=[WHLINVTY].[FBM ID]")

Richard

 

[Guest_imported]

Tried that N.G.

OK, I found If I set the form SEND OUT FOR REPLATE OrderBy property to a Date field in the "Strip Replate" table it works fine. Question then is how do I make sure that orderby property is set at after update.

 

[huzza]

That's strange! It still asks you to enter the parameters manually? oh well.

If you want to change the orderby property on the form in code use the following:

[forms]![SEND OUT FOR REPLATE].orderby = "fieldname"[code]
obviously replace fieldname with the name of the field you want to sort by.
Richard

 

[huzza]

Hi,
replace both instances of [ with [ in my previous email
Richard