Passing text value from Form1 to bound text in Form2? 1

[Apollo6]

I have frmMain with txtPatientNumber. When I click a button, a new form opens to enter drug history. It contains a bound field, txtPatientNumber, as well as other bound fields that the user would enter data. I want it to automatically populate with the current patient number from frmMain to be entered into the drug history table. Basically, the user doesn't need to enter the patient number, I'll just grab it from frmMain, which is still open.

I know I have done this before, for the life of me, I can't get it to work now. Just need a refresher on how to go about this. I keep getting an error stating it can't assign a value to the txtPatientNumber bound text box I have on the second form.

Any help is appreciated.

 

[TheAceMan1]

How are ya Apollo6 . . .

Note: if [blue]txtPatientNumber[/blue] is a [purple]primarykey[/purple], this wont work (duplicate PK!).

In the Load event of the Other Form:

[blue]   If Not Me.NewRecord Then DoCmd.RunCommand acCmdRecordsGoToNew
   Me!txtPatientNumber.DefaultValue = Forms!frmMain!txtPatientNumber[/blue]

Form frmMain just open the Other Form with DoCmd.OpenForm . . .

See Ya! . . . . . .

 

[Apollo6]

Better now. I got that to work with your suggestion. Must have been having a brain cramp.