Records displayed should only show users records

  • Thread starter Thread starter Keith Bemis
  • Start date Start date
K

Keith Bemis

Hello,
Please help me I have 4 locations that use the same
database, I would like each location by default only see
their location's records. Inside database there is a field
that lets users choose where that patient is scheduled for
an appointment..but as of now they see all records ...
thank you,
Keith Bemis
 
In the Open event of the form, you could set its RecordSource property so as
to display only the records for the location.

Example:

Private Sub Form_Open(Cancel As Integer)
Me.RecordSource = "SELECT * FROM MyTable WHERE Location = " & SomeNumber
& ";"
End Sub
 
Back
Top