Form Samples

[Guest_imported]

I'm a Form newbie. Anyone know where I can find Access 97 sample Forms?

I've created a database for our service department and am developing data entry forms. I've been able to create basic forms with Combo boxes but I need something more complex. If a user selects a Group ID from the first combo box, I want only the stores within that Group displayed in Store List.

 

[SyedAqif]

Hi

When u'll c the properties of ur 2nd combo box, under data tab u'll find row source property. for that row source write ur query as:

select StoreID,StoreName from TblStore where TblStore.GroupID=Forms!MyForm!Combobox1;

On after update even of 1st combo box just write

DoCmd.Reuqery "Combobox1"

Hope it'll help u

Cheers!
Aqif