add record, then edit same

[redFred]

Hi all. I open a form, complete some data entry then, using a button, call a
popup form for entering greater detail. Then I close that popup. BTW, the
first form remains open all the time.

My world is fine until I want to go back and edit that popup form. The form
displays correctly, with the data I previously entered...however, I am unable
to enter anything...it just beeps at me.

The code I use to open the form is: DoCmd.OpenForm stDocNameBC, , ,
stLinkCriteria, acFormEdit.

As I said, the form opens with the correct date, just can't change it. What
should I be looking for to correct? The form is set to adds/edits/deletes to
yes, the controls are enabled and unlocked.

Please help!

Thanks,

 

[redFred]

Thanks, Allan. Each form is bound to its own query. Access 2007.

 

[John W. Vinson]

The code I use to open the form is: DoCmd.OpenForm stDocNameBC, , ,
stLinkCriteria, acFormEdit.

As I said, the form opens with the correct date, just can't change it. What
should I be looking for to correct? The form is set to adds/edits/deletes to
yes, the controls are enabled and unlocked.

My guess is that Access is confused about which form is "in charge"; if you
have two forms open, both editing the same record, there is a potential
conflict.

Why two forms? You might want instead to consider ONE form with a tab control
to provide more screen space.

 

[Evi]

If RedFred has a wide, datasheet subform and wants the popup so that he can
complete each record whilst still being able to view the list of records in
his sub, can this be done with a tab control?
Evi

 

[redFred]

First...thanks to you all. I think its ok now. Time will tell! For an
unrelated reason I reordered the code calling the form. Subsequently, I
tried again on the off-chance it would work and - voila! Success. Not sure
why, but the function works. BTW, I did rebuild the db; seems I get a GoSub
error on occasion in Access 2007 when I delete some code or multiple controls
at once. After rebuild I still could not get the edit to work, but after
reworking the code it did.

I wish I knew so I could post to help someone else. Alas...