Using command button to carry data into a form

[cardgage]

Haha no worries, the help is much appreciated!

[RuralGuy]

Try this sample. The Orange TextBox does not need to be there.

[cardgage]

Thanks so much for the help! However, the same problem is occurring. PatientID gets passed into frmAdmissions OK to view existing admissions for that patient, but when I try to add a new record PatientID is lost (as evidenced by the orange text box being empty and by Access saying that the admission can't be tied to a patient).

Any other ideas?

[RuralGuy]

Go to the frmAdmission form in design view and on the Data tab of the properties sheet set DataEntry to YES and try in again.

[cardgage]

Changed it, still doesn't keep PatientID...how exactly does OpenArgs store the data in the string? Is everything I had with the VB code OK with that?

[RuralGuy]

Are you trying to add more than one record at a time without returning to frmMain?

[cardgage]

My intention was to have frmAdmission open up (with the selected PatientID active) and use it only to enter a new record (admission) for the selected patient. In other words, I wanted the selected PatientID to remain active until frmAdmission was closed.

[RuralGuy]

See if this is closer to wnat you wanted.

[cardgage]

Wow, that's perfect, thanks!

One final question...say I add a new patient to the patient list that cmbPatientSelect searches for using the cmdNewPatient button. Then, I want to add an admission for that patient using the cmdNewAdmission button. Currently, I have to close the database and reload it. Is there a way to refresh the data list so I don't have to close out of the program?

Thanks again for all of your help...very much appreciated!

[RuralGuy]

Try this one!

[cardgage]

Perfect! I've implemented these into the active database, and everything is working well. Thanks so much for your help!

[RuralGuy]

Glad we could be of help. Code is sooo much easier to work in.