Access - Form Data Entry Problems

[Guest]

HI

I have used the advice at
http://office.microsoft.com/en-us/assistance/HA011730581033.aspx to create a
simple form containing three fields of combo box lists. They all contain
selectable data dependant on the choice in the previous field.

However, i cannot get the Requery function to work for the third fieldwhen
changing a choice made in either of the first two fileds. The content remains
as it was for the original choice and subsequent field relationship.

Can someone please explain how i can get the third field to update its
content when I change a previous filed?

Also, the record navigation buttons are not active on the form, meaning I
cannot enter data for mutiple records - how do I enable automatic new record
selection when entering data via forms.

Please help, thank you.

Fenrir

 

[Guest]

Hi

I have now actually managed to work out how the requery works (being a bit
dim I'd linked it to the wrong table!).

However, still cant manage to get to a New Record form when Ive finished
entering data for the current record!!

Thanks
Fenrir