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

Drop-Down list, forms and exporting

P: n/a
Dec
Ok to simplify things I'll just give an example.
This is pretty much what I want to do (minus the postcode):
http://www.perrys.co.uk/usedcar?ID=F5J9BNNBMVK00DF

I have relatively little experience with databases (hate being a n00b)
but I'm currently attempting to put myself through some sort of crash
course..

How far have I got?
Ok so using MS access 2003. I have a table (table1) with data with a
bunch of cars on them: make, model, price etc.
I go into forms, new form and form wizard, with the objects data
coming from table1. Click OK and create a form with (lets just say)
"Make" in it. I want a drop down list box so in the form design view I
right-click on it and "Change to"... there's no drop-down list box
only "list box" and "combo box" even though "help" said there would
be. So I picked Combo box cos it looks like a drop-down list. I don't
know how to use it though and I'm obviously way off. I'm thinking it
has something to do with needing a query right? (stupid stupid
newbieness, at least I'm probably making you laugh) Basically what I
want to be able to do is get a drop-down list (not a fixed list) of
Makes of cars and when I click on one of them I get a tabular view of
all the cars of that make and their details.. Is this possible and
relatively easy? God please say yes.. Any insight anyone could be
offered would be great..

Cheers

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


P: n/a
A Combo Box is, in fact, a "drop-down list box", that is a text box into
which you can enter information with a list that drops down when the Combo
Box gets focus. If you create the Combo Box with the Control Wizard enabled
(the little box in the toolbox with the magic wand will appear depressed),
it will lead you by the hand (or, perhaps, tug you by the ear) through the
process of creating what you want.

So, once you have done the autoform (as it appears you are doing), delete
that Control, and use the Toolbox to create the Combo Box with the Control
Wizard enabled.

You might invest a minimum amount in a good self-study such as John Viescas'
"Access 2003 Inside-Out" from Microsoft Press. Or perhaps in the more
elementary "Microsoft Access 2003 Step by Step", also from Microsoft Press.

Larry Linson
Microsoft Access MVP

"Dec" <co******@tcd.ie> wrote in message
news:67**************************@posting.google.c om...
Ok to simplify things I'll just give an example.
This is pretty much what I want to do (minus the postcode):
http://www.perrys.co.uk/usedcar?ID=F5J9BNNBMVK00DF

I have relatively little experience with databases (hate being a n00b)
but I'm currently attempting to put myself through some sort of crash
course..

How far have I got?
Ok so using MS access 2003. I have a table (table1) with data with a
bunch of cars on them: make, model, price etc.
I go into forms, new form and form wizard, with the objects data
coming from table1. Click OK and create a form with (lets just say)
"Make" in it. I want a drop down list box so in the form design view I
right-click on it and "Change to"... there's no drop-down list box
only "list box" and "combo box" even though "help" said there would
be. So I picked Combo box cos it looks like a drop-down list. I don't
know how to use it though and I'm obviously way off. I'm thinking it
has something to do with needing a query right? (stupid stupid
newbieness, at least I'm probably making you laugh) Basically what I
want to be able to do is get a drop-down list (not a fixed list) of
Makes of cars and when I click on one of them I get a tabular view of
all the cars of that make and their details.. Is this possible and
relatively easy? God please say yes.. Any insight anyone could be
offered would be great..

Cheers

Dec

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.