Unbound text box repeats for every row on a continuous form.

  • Thread starter Thread starter SoDakRah
  • Start date Start date
S

SoDakRah

I have two text boxes on a continuous form. Text2 is populated from the
value selected in Text1. Text2 is unbound and repeats the text on every line
displayed once the value is selected in Text1. I do not want to bind Text2
to a table/query as form is a purchase order receipts data entry form and
needs to draw information from the item master table so the user can verify
the data entered, yet not store that item master information in the PO
reciepts table.
 
Text2 is populated from the value selected in Text1.
What is your formula to populate Text2?
 
On the after update event of Text1, I open a recordset with an SQL query and
retrieve the information I want for Text2. I can get the information I want
by binding the text boxes, but was hoping to not duplicate information in
more than one table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assigning values to text for calculation 0
If a control contains this value, do this... 6
how to print report by check condition in textbox in form? 2
access 2000 problem 7
Populating Text Field 1
Conditional Formatting continuous form using VBA 9
Search criteria for querys 3
enable field based on value of another 7

Back
Top