RECORDS FROM NEXT COLUMN APPEAR IN FORM TEXT BOX

[baybie]

I have a table called centres which has 4 columns 2 of which are called 'State' and 'Collection Centre'.
I have now created a form from this table, the state and Collection Centre boxes are "combo boxes" and would like when a state is selected, the Collection Centre combo box will automatically display the centres located in the selected state.
I tried something like this in the After Update command:

Private Sub State_AfterUpdate()
Me![Collection Centre] = Me![State].Column(2)
End Sub

Didin't work at all, kept getting various errors like "Cannot the field 'state' specified in your command

 

[KenReay]

Hi

See forms Forum FAQ, under comboboxes

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[baybie]

BRILLIANT, WORKS PERFECTLY!!