Is it me or is it the Form?

[rbinder]

Greetings all,

This is the strange scenario that is playing out.

Through a switchboard I click a button, opening a form (Grape Intake)with two sub forms. Then happily enter data and everthing is fine.

I have then set up to open a form (Job Orders Intro) from the swithboard. On this form I have a button Grape Intake. I press this and the Grape Intake form open. Data entry is fine until when I try to add a second record to the first sub form I get the error message;

Run-time error '2105'
You can't go to the specificed record

I am absolutely as to how to solve the problem. Any help would be great.

~rbinder

 

[amerfeld]

Not quite sure I understand how your forms are set up, but try Requerying the underlying tables in the afterupdate event of the form. Or try refreshing the form: form.refresh.

Hope this helps.