P
Pat Dools
Hello,
I need to adjust the following code to be able to pick only 3 fields
(edrecno, ptin, patient) from a record that has a lot more than 3 fields.
This code selects a distinct row of records, but each row only has 3 fields
(columns):
Private Sub SelectPatient_Change()
Me.RecordSource = "SELECT DISTINCTROW LU_Patient.* " & _
"FROM TableEdit" & _
"WHERE
(((TableEdit.patient)=[forms]![fEnterPatientInfo]![selectpatient]));"
Me.DataEntry = False
Me.Requery
End Sub
What I want is to capture the 3 fields on this form, so that they will be
available to carry onto the main Patient Form (as long as 'fEnterPatientInfo'
remains open). I have this working in a similar Access application when
looking up to a 'Patient Lookup' table that has only 3 columns (fields) for
each record, but what I want to do now is pull 3 specific columns from a
record with a lot more than 3 columns (fields).
Thanks.
I need to adjust the following code to be able to pick only 3 fields
(edrecno, ptin, patient) from a record that has a lot more than 3 fields.
This code selects a distinct row of records, but each row only has 3 fields
(columns):
Private Sub SelectPatient_Change()
Me.RecordSource = "SELECT DISTINCTROW LU_Patient.* " & _
"FROM TableEdit" & _
"WHERE
(((TableEdit.patient)=[forms]![fEnterPatientInfo]![selectpatient]));"
Me.DataEntry = False
Me.Requery
End Sub
What I want is to capture the 3 fields on this form, so that they will be
available to carry onto the main Patient Form (as long as 'fEnterPatientInfo'
remains open). I have this working in a similar Access application when
looking up to a 'Patient Lookup' table that has only 3 columns (fields) for
each record, but what I want to do now is pull 3 specific columns from a
record with a lot more than 3 columns (fields).
Thanks.