Search results

Hi and thanks for your interest, I'm creating a database to produce transcriptions in a medical office instead of having to go through a transcription service. I have a main form with multiple subforms(4) and tabcontrols(2). The subform I use to enter medications is based on a control box...

It does! Thanks again. I really appreciate it. -Jenny

You are brilliant! It worked! Thanks so much!!!!!!!!!!!!!!!!!!!!!!! It was because previously I had named the field Patient ID, then renamed it PatientID to make the coding easier. Wow. Thank you!!!!

It used to be Patiend ID, but I changed the field name in the table and on the report. OH! I just noticed that on the report field list, it's still Patient ID. Is that why?

It is in the report's field list, but I chose not to put it on the report. I actually just tried adding it to the report but it still didn't work. The command button still prompted for patientid.

Both codes work fine, if I want the command button to prompt me to enter the PatientId... I see the patient that is assigned to that ID on the report. What I'm trying to do is click the command button and it grabs the PatientID that's on the current form, without me having to type the PatientID.

It's numeric, but no, I don't patient ID on my report. Is that what I need to do? If so, could that field be hidden? Thanks for replying. I'm going to try your code... Thanks :)

I've been trying to figure this out for hours now. I need the code to Preview a report for only the current record on my form without prompting for the ID. I'm making a patient report database. This is the code I'm using now... is there a way I could simply revise this code so I won't have to...