How? Use DLookup text box to enter records, not view only 1

[etalent]

Forms!frmPentaling!txtSyn = DLookup("[fldSpaSyn]", "tblVoc", "[fldVocID] = " & Me!fldVocId)

----------------

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

 

[dRahme]

http://www.todayskills.com/msaccesstutor/msaccess.htm

 

[TheAceMan1]

How are ya etalent . . . . .

This is all very vague & open . . . [blue]Be more specific about your needs![/blue]

See Ya! . . . . . .