Button to open new form triggers the form and the filter shows the proper key but screen is all blank

#1 August 10th, 2006, 10:15 AM

I have a button on one screen that opens another form.

If I click it then the form opens but the fields are all blank.

I look at it in Design view and the filter shows the proper key.

If I close the new form and click the button on the 1st form again to open
it then this 2nd time the data shows correctly.

It is weird as I simply created an edit screen from the table and limit it
to the single record. This is simple and should work, but like many times in
Access it doesn't.

Any help here would be greatly appreciated!

Thanks,
Steve

#2 August 10th, 2006, 10:45 AM

"Steven Little" <legends13@verizon.netwrote in message
news:rTCCg.4870$f8.3071@trndny09...

Quote:

>I have a button on one screen that opens another form.
>
If I click it then the form opens but the fields are all blank.
>
I look at it in Design view and the filter shows the proper key.
>
If I close the new form and click the button on the 1st form again to open
it then this 2nd time the data shows correctly.
>
It is weird as I simply created an edit screen from the table and limit it
to the single record. This is simple and should work, but like many times
in Access it doesn't.
>
Any help here would be greatly appreciated!
>
Thanks,
Steve
>

What's the code behind the button?

Keith.