About Rob Henderson Expertise I can answer most MS Access design questions. I also welcome questions on database design and implementation and VBA programming questions.
I also have expierence in application design for all the Office components (Excel, Outlook, etc).
This is the code that works perfectly as far as viewing, but I still need to be able to enter new records. This code doesn't give me that.
The text boxes on the main form, in this case "txtSyn", is unbound presently. They have no record source, so I suppose I have to give them a record souce, or would I dimension a record set?
Please tell me what to do with the "Antonym", "Synonym", and "Example" text boxes on the main form, so that I can use them to enter new records too, not just view existing records.
-Thanks
Answer Hi
If this doesn't work for new records it must mean you do not have the data that this expression requires.
This is probably because you haven't saved the new record before attempting to rretieve the information.
Try running DoCmd.RunCommand acCmdSaveRecord before you attempt to retirieve the info.
