Hi there,
Three tables.
Craete record on first table on form1 which has a button to next form which create the record on 2nd table which in turn has a button to open a form to create record in 3rd tables. However always get error to say there a related record required in 2nd table. I have checked and get someone else to check for me and the record did existed.
Since my posting, I found that the computer may be infected as the effect is so unpredictable. For example, I have a statement which is docmd.close but it closed the whole application instead of one form. The requery statement doesn't work. created record was deleted etc. At present doing a virus check on the computer abd should know the result tomorrow.
Does my above method work, in case it is not the work of virus.
