Able to view all records for a staff member

[BSJoJaMAx4]

I have a conference centre database with a main menu using switchboard. I have also included a tab option to view live records ie upcoming bookings in the next 7 days etc. As part of the tab option, I want the user to be able to enter a persons name in a combo box (using previous records) and it then bring up all records associated with that name. As per attached, user has selected Fred, then I want to retrieve all the bookings that Fred has made (sorted by newest to oldest).

[orange]

general query will be something along this structure

Select * from Bookings
Where BookingAgent = Me.[Quick Find Name]
Order By BookingDate Descending


Note: DATE is a reserved word in Access

[BSJoJaMAx4]

Hi Orange - sorry but having one of those days. I can see how I want it to work but using your instructions cant seem to get it to work. Can you step by step me a bit (sory Im real raw with access)
Table name is Booking Master Data
Data for name is: Booking Officer
Date of booking: Booking Date

[orange]

The preference of many experienced developers is to not use a naming convention that allows embedded spaces in field and object names.

General case:

SELECT * FROM yourTableName
WHERE yourFieldName = yourCriteria
ORDER BY yourSortFeldName sortOrder

SELECT * FROM [Booking Master Data]
WHERE [Booking Officer]= yourCriteria
ORDER BY [Booking Date] descending

yourCriteria is the selected value from the combobox.

Research techonthenet combobox

[BSJoJaMAx4]

Hi Orange

Have tried to work on this further but with no luck.

I have created a query using the fields in the database.

I created a form which displays the data and using a combobox to get the data from the name.

Do I add the code

SELECT * FROM [Booking Master Data] WHERE [Booking Officer]= yourCriteria ORDER BY [Booking Date] descending

in the query or the form?

[orange]

What is the name of the combobox where Fred is located in your post #1?

You have to enter your required value for yourCriteria in post 5.