Lookup not working

[sharon attwood]

I have created a table which has a lookup box linked to another table with a bound column reference. The lookup works in the table.

On the form I have linked the original table to a query table which does a calculation based on the result of the lookup and another field.

Everything was working until I tried to put it in a report and deleted something by mistake. Now the drop down and calculations are visible on the form but I can't add a record or change the values in the drop down. The actual field appears blank. I have had to replace a lot of the relationships so I think the problem's something to do with that, but I can't seem to find it.

Does anyone have any idea what I can start looking at?

Sorry to be so vague, but I have tried to attach the database in a previous query and it is too big.

This is really frustrating 'cos I finally managed to get it working, then broke it, so any help would be gratefully appreciated.

 

[ssoltic]

Try to add records on that query. If want post database tossoltic@gmail.com I can check whats wrong.

 

[sharon attwood]

Thanks for the offer

I have tried to send the file as it is and a zipped version but our server at work is blocking it so I can't send it to you

Thanks for the offer anyway

Sharon

 

[sharon attwood]

I found a backup before I broke it and re-built all the bits that are missing so I'm able to carry on now.

Thanks