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

  • Thread starter Thread starter SueM
  • Start date Start date
S

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
 
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...
 
Back
Top