Inquire and Update on Form

[Ronald Dodge]

How do you setup a record ID field on the form to be able to inquire on the
record without no other field entered, even if any other field is marked as
required.

Also, but the same token, how do you prevent this ID field from being
*CHANGED* in the table within the BE file, when you enter a value for the
field in the FE file to inquire?

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

 

[Guest]

Use an unbound textbox that is used as criteria in your query for the form.
Then in the After Update property create an event to requery.

 

[Ronald Dodge]

Well I attempted at using both the Requery and Refresh methods on the form
dealing with the unbound control, and that didn't work. However, the
following VBA command did work, which I don't understand why I have to use
the "OpenForm" command in order to do what I'm attempting to do, when the
form is already open.

DoCmd.OpenForm "frmEmp", acNormal, ,
"[Forms]![frmEmp]![tbxfldstrEmpID]=[tblEmp]![fldstrEmpID]", , acWindowNormal

None the less, this command does work for what I'm attempting. This method
also involves using a bound textbox and an unbound textbox. Once I'm done
with the various things that I'm attempting at building and testing, I will
then have the bound ID field as hidden and generally both disabled and
locked, though at certain points of times, it may need to be unlocked and
enabled such as just before it goes to actually add a new record.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000