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

Filtering data entry in forms

P: n/a
Hi all,

I'm still fairly new to Access and I was hoping to get some assistance
with something I have yet to accomplish. The desired result is a form
where users can enter data but for a few select fields, the data that
is available to be entered is filtered based on a selection made in
another field.

Right now, I have a table created for the form where customer
information & payment information are standard text fields. There is
also a field in this same table that is a lookup column referencing a
list of reasons for entering the record.

I have another table with a list of resolutions that depending on the
reason selected in the form, only a portion of the resolutions should
be available. In the resolutions table, I have each resolution, and in
another column, the corresponding reason that it should be filtered by.

First, do I have this set up correctly to incorporate this into a form?
Second, if this is the correct setup (or even possible) how can I set
the form up to filter a field based on another field's selection?

Thanks,

Chris

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
This is the standard "filter one combo/listbox based on the contents of
some other control", so read this article:
http://www.mvps.org/access/forms/frm0028.htm

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.