Forms help required

[martin james]

I am quite new to Access and databases in general.


i want to create a form where one field uses a lookup (I can do this without problems). Then i want the next field to to be a lookup depending on the value entered into the previous field.
I imagine this is quite simple but i have looked at many books but none provide an answer

[pbaldy]

Does this fit the situation?

http://www.baldyweb.com/Autofill.htm

[martin james]

not really i don't think. It may be the way i am explaining it. remember i am new to this.

I have a form created from a table to enter data into the table. in on field i have a lookup, drop down with a number of choices.
In the next field i want a drop down with several choices but these choices are dependant on the choice made on the first field.
Example first field has drop down with choices A, B, C.
Feild two has drop down of 1,2,3 if A is entered into field one, but a drop down of 5,6,7 if B is entered into field one.

I am trying to teach myself to build a database and getting over this hurdle will help lots.

Thankyou in advance to anyone who can help me with this. Please keep the answers in very basic terms for me though like press this highlight that.

[pbaldy]

That sounds like this:

http://www.baldyweb.com/CascadingCombo.htm

[martin james]

Not got to the vb stuff yet. is there a simpler way of doing this?

[pbaldy]

Simpler than those two? Not that I'm aware of.