Datasheet view in subform??

[lmcm1977]

Hi

I have a form created in my database (database has one to many relationships) . In the top part of my form I have the demographic details for the person which never changes but then I have a subform which has the list of appointments and appointment details that the patient has attended. these are showing in a datasheet view at the moment but I wondered if I can change this to show in a tabbed format? each tab would have a label saying "appointment 1" "appointment 2" and so on?? the datasheet view isn't very userfriendly to view at the moment and im not sure whats the best way to change this.

thanks in advance!

best wishes
lynn

[ranman256]

you can have a 'tab' control to hold the subform, but not a tabbed forms like the master form.
you shouldn't use tabs for each Appt ,then youd have infinite tabs.

i'd have a combo box above the subform to hold all the Appt Dates.
user can enter or pick a date, then the subform would filter on that date,
no date would show all Appts.
the query "qsApptBy1Date", would use the combo box as criteria:
select * from appts where [ApptDate]=forms!myForm!cboBox

sub cboBox_Afterupdate()
If IsNull(cboBox) Then
  me.subform.sourceObject = "qsAllAppts"
Else
  me.subform.sourceObject = "qsApptBy1Date"
End If
end sub

[Micron]

If you might want to see 2 or 3 appointments consider a listbox to multi select appointments from a list. Or if a date range is more conducive, filter the datasheet by date range - two textboxes with start and end dates.