Return field values based on choice in previous field & fillin day based on date

[SueM]

Hi,

I'm making a table that depends on several other tables
for it's information.

In field2 the user will choose a product range. In field3
they will choose a product. The list of products in
extensive so I want field3 only to pick up the products
within the range chosen in field2.

How do I do this?

I managed this on a form. But couldn't figure out how to
get the items chosen in the form back to a new table.

In the form I used the following:
SELECT [Query1.PdGrp_Desc], [Query2.Pd] FROM Query2 WHERE
[Query1.PdGrp_Desc]=Combo29;

Also I want the user to be able to fillin the date in
field 4 and for the day of the week to automatically
fillin field 5 andy ideas on how to do this?

Cheers,

Sue

 

[Rebecca Riordan]

Sue,

Make sure that you've set the bound column of the Field3 listbox to the data
table, not your select query. It should work; I'm sure you just need to
fiddle with the properties a little.

As for the day of the week, use the Weekday function.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...