Ok, thanks. Because it seems that you really know what you're talking about,
can I ask you another, somewhat unrelated question?
On another form, I have eight subforms, one for each product. Each subform
is based on a query that has all the products. I want to filter the subform
to only show a certain product, say "cash". How would I do that?
I tried putting an event in the OnCurrent property
Me.Filter = [S M D S].IAS = "Cash"
Me.FilterOn = True
but it's not working. Do you know another way to do this?
Klatuu said:
It is a bit more clear, but the are certainly details I am not aware of.
If you are going to create an order for a customer and the first 8 products
are always the same, then it may be a good idea to programmatically create
the first 8 records (I assume) programmatically and present them in a sub
form so the user can select the optional properties for the items. Then they
should be able to add items using the combo.
:
I have a continuous subform where the user choose the products that they want
in a gift basket. There are always 8 of the same product for each basket
(the user can still specifiy color/flavor...). After the first 8 products I
want the user to be able to choose whatever they want.
I am sure that I want those first products to be visible in the form (I
thought about just displaying the extra products but don't want). Hopefully
this clears this up.
:
I am not understanding what you are asking. How does what is in a combo box
list relate to a user having to enter the same value repeatedly? Can you
give me a description of what you are doing?
:
I have it set already so that you can enter text that isn't on the list. The
issue is that all of the first 8 entries will always be the same for each
page. After that there might be new/different entries. Is there a way to
make the first entries automatically appear so that on each record the user
doesn't have to enter the same information again and again? Thanks.
:
If you set the Limit To List property to No in design view, but include your
8 options, then you can enter anything you want in a combo.
:
I have a continuous form that has a combo box option. Is there a way that I
can make a default on the combo for the first 8 options and then allow free
additions after that?
For instance, the first entry would be the first default, the second entry
would be the second default....., the ninth entry would be open/free.
Thanks!
