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

Not in the list

P: n/a
I have the following problem.I have a form and a subform based on a
query,and this query does not allow the choice of other products.And it
is quite logical, since the parameter is (SELECT Max([orderid]) FROM
orders).
Naturally no other product can be chosen. I am wondering can i find
a trick with both to have the cake and to eat it.I mean to preserve the
condition and at the same time to be able to choose and add other
products from the table products.Shall i change the source or use some
NotIn the List methods?

Feb 27 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
solar wrote:
I have the following problem.I have a form and a subform based on a
query,and this query does not allow the choice of other products.And it
is quite logical, since the parameter is (SELECT Max([orderid]) FROM
orders).
Naturally no other product can be chosen. I am wondering can i find
a trick with both to have the cake and to eat it.I mean to preserve the
condition and at the same time to be able to choose and add other
products from the table products.Shall i change the source or use some
NotIn the List methods?

Hi,

What do you want to obtain as a list?
First guess: all orders:
SELECT OrderID FROM orders ORDER BY orderID DESC

Stevel
Feb 27 '06 #2

P: n/a
Thats what i want, to be able to add new products to the list.Because
the list conatins the number of the items in the last order,and i want
to be able to edit and add it

What command should i give and where to change the source?

Feb 27 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.