I have a frm (frmWMS) which has 4 fields,
Location, Room, Number and Quick dial
Its based on qryWMS which has one criteria in the Location field, therefore the form shows all the results for bath or bristol or wherever the user selects.
I have gone to add a combo box that lets the user select a record based on which room they choose in the combo box, but when i use the wizard it says unable to retrieve data......
I can see no reason and its driving me nuts, ive searched for everythin i could think off!
Location, Room, Number and Quick dial
Its based on qryWMS which has one criteria in the Location field, therefore the form shows all the results for bath or bristol or wherever the user selects.
I have gone to add a combo box that lets the user select a record based on which room they choose in the combo box, but when i use the wizard it says unable to retrieve data......
I can see no reason and its driving me nuts, ive searched for everythin i could think off!
