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

Creating a "shopping list"

P: 1
Hi, ive got this problem with one of my databeses.

My question is, how do i create a sort of a shopping list on access?

Im doing a ficitional pizza shop, and what i want to do is to have an order form. In this form i would like to be able to select an item from the combo box and then after an item is selected another combo box appears, and the items selected in those combo boxes appear on a report.

Thats what I mean by shopping list haha
if you could help me that would be awesome! :D

Jul 20 '07 #1
Share this Question
Share on Google+
4 Replies

P: 65
Could you be more specific??

What i think now is that you have a form with 2 fields to choose from. When you choose from the first field the second should apear.

(from your form)
Expand|Select|Wrap|Line Numbers
  1. Private Sub TypeChoise_change()
  2.     typechoise2.setvisible
  3. End Sub
I don't think the syntax is correct but this is a way to use them.

To fill your report with the values of the choises, can be done in verry much ways.
I did this like this:
(from your report)
yourfield.Caption = yourform.typechoise
Jul 20 '07 #2

Expert 2.5K+
P: 3,532
The technique you're speaking of is referred to as Cascading Comboboxes. Here's the link to a tutorial on the subject. Give it a tyr and let us know if yu need any help.

Welcome to TheScripts!

Linq ;0)>
Jul 20 '07 #3

Expert 2.5K+
P: 3,532
And Twanne, you're correct! The syntax for making a control visible isn't


in VBA but rather

typechoise2.Visible = True

A Welcome to TheScripts to you, also!

Linq ;0)>
Jul 20 '07 #4

P: 65
thx, setvisible is from java I think

I'm even not a real programmer I'm a networkdeveloper who needs to build a stupid database in access. Why couldn't they give me something else, I said with sarcasm dripping.

Jul 20 '07 #5

Post your reply

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