No, sorry. I understand the first part, but not the second.
Writing code to populate a text box from a button click is easy. The rest of the sentence from that point onwards doesn't make sense.
- What does the query do - display a recordset, perform an action or something else entirely?
- What is ID - a text box, a button to generate a unique number, an idiot detector or something else entirely?
- What input? A control on the form, an input box prompt or something else entirely?
- Is the table bound to the form, bound to a subform on the form in question or another table within the database?
If you can clarify what you have, and what you need, more help might be forthcoming.
Private Sub cmdLazyWeb_Click()
Dim strOutput as String
strOutput = "Blah blah blah"
txtCertain = strOutput
10% of magic is knowing something that no-one else does. The rest is misdirection.
Beers earned: 2