What am I doing wrong

[Geoff Codd]

I have a db (attached), which contains a form and a sub form on the subform you select a location from a combo box, this is then related to the site of the main form. The problem I am having is that the other 2 fields are not populating themselves until I move to another record then back again.

The second thing I want to do is have the combo box only show records which have yet to be allocated to a site, but if a record is removed from a site then it will reappear in the combo box

Any advice always appreciated, this is probably somthing very simple but my brain has gone to sleep. I am so glad it's friday

Thanks in advance
Geoff

 

[Geoff Codd]

I am still having problems, when I delete a record from the subform it is deleting it from the lookup table rather than just groups table as well as the table tblAggregation_Site_Details. which I do not want to happen. I need it to be made available again for adding to an alternative site.

Thanks
Geoff