By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,341 Members | 1,553 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,341 IT Pros & Developers. It's quick & easy.

ListBox, ComboBox criteria and query

P: 2
Hi all,

I am troubled by this problem, I'm new to ACCESS (last time i touched base on VBA codes was 5 or 6 yrs ago where I took Microsoft Visual Basics for beginners)

Please help! My workplace was to develop a search and traceable system for their customers and job orders, I've put in some of the data in tables.

The Scenario is a CUSTOMER, CARS, JOB ORDERS picture.

A customer can own more than one car.
A car belongs to only one customer.
The car can have more than one job performed on it.

I have the following:

1 Tbl for CUSTOMERS (name, address, phone no. etc)
1 Tbl for CARS (make, model, yr..)
1 Tbl for JOB orders (i.e. CarRegNo. or CarTagNo., JOB DATE, Jobs performed in list, cost)
1 Tbl for Job Description (list of jobs i.e. engine washing, adjust handbrake)

I need to have them all displayed on 1 main form.
Problem is I don't know how to connect them together. My idea was that on a clean MAIN form, there's a combo box of CarRegNo. or CarTagNo. Then it will filter out to its JOB DATE. Then from the JOB DATE will display its corresponding JOB DETAIL.

I'm happy to use subform/s. I don't know how to link all of it together. It seems like coding needs to be involved. That's fine with me, but I don't know how to go about it now.

Please help
Jul 28 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.