Microsoft Access Command Buttons for subforms

crystal100472 · May 18th, 2010, 10:27 AM

Microsoft Access Command Buttons for subforms

I'm creating forms for a medical Chart database and I'm looking to have Command buttons to open forms and have them auto populate the Patients unique Patient ID number. I've set the primary Key as the Patient ID but when I add in the Command buttons they are not populating the Patient Id.

Also a different Issue I'm having I've set field size as 1 and would like after that one number is entered in for it to auto tab to the next line. I'm not sure what I'm doing wrong with that also.

I'm a bit new to access so any help would be very appreciated.
I'm trying to get this database up and running today... ?

gbianchi · May 18th, 2010, 10:32 AM

Really hard to help you if we don't see what you are doing...

crystal100472 · May 18th, 2010, 10:52 AM

Quote:

Originally Posted by gbianchi

Really hard to help you if we don't see what you are doing...

I'm sorry. I don't know much of the coding of access.

What I do is on the main form I add a command button go through the steps off adding it link it to a form and save and then go to test it and it opens up the form but not with the PatientID auto filled.

Does that make any sense?

gbianchi · May 18th, 2010, 11:40 AM

I don't have much experience on access.. but please tell me that somewhere you put the SQL or the table the data came from, and also that you put the field/s you are using to filter the data...

crystal100472 · May 18th, 2010, 11:44 AM

Quote:

Originally Posted by gbianchi

I don't have much experience on access.. but please tell me that somewhere you put the SQL or the table the data came from, and also that you put the field/s you are using to filter the data...

Yes I have created tables and created forms and subforms. When I put the subform in the main form the linked ID(patientID) is auto filled in the subform.

What i'm trying to do is create a command button using the command button wizard and linking it to the main form and the button works but is not putting the linked patient id field in the form. Am I not explaining this correctly?

SerranoG · May 18th, 2010, 04:21 PM

The second question is quicker to answer so I'll do that first.

If you have a field, say it's called txtGender (M for Male, F for Female), you can code an afterupdate event. Suppose the next field is called txtAge. Then...

Code:

If Len(Trim(Nz(Me.txtGender,""))) > 0 Then
    Me.txtAge.SetFocus
End If

The code above makes sure the Gender textbox has a value. If it does, it goes on to Age. Note that I didn't make it Q/A the data to see if it made sense, e.g. allow only M or F.

If users use the TAB key after entering data, this afterupdate event is not necessary. If they use the ENTER key, it is. People should get used to tabbing, but some don't.

As for your first question, when you created the subform, the wizard should have asked you to supply and parent/child relationship from form to subform. In your case, it's the Patient ID. That relationship is not created by the addition of a command button. If the command button's function is to add a new record in the subform, note that the Patient ID will not autofill (assuming parent/child link is correct) until after you start entering data in another field in the subform.

KurtBergman · May 18th, 2010, 10:39 PM

Crystal...
what form is the Button on and what form is the resulting Patient ID to be displayed? What is the code behind the ButtonClick event?

as for your second question, use one of the text box's events to trigger the move to the field. Such as OnKeyPress (I haven't used Access for awhile so this may not be a valid event) the point being, there are events that occur when a key is pressed on the keyboard and they can be captured via code to do some type of work

ex: If somekeyevent then
do what I want
end if

I hope this makes sense