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

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.
 
K

KARL DEWEY

Text2 is populated from the value selected in Text1.
What is your formula to populate Text2?
 
S

SoDakRah

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.
 
K

KARL DEWEY

Why not just join the second table or query in the query that feeds the form?
 

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

Using a continuous form for data entry 8
how to print report by check condition in textbox in form? 2
Filter an Unbound field on a SubForm 1
Unbound control on continuous form goes blank 1
Filter subform from combo unbound text box 3
Timesheet-bind an unbound text box expression to a table 6
Displaying info in an unbound text box and locking for editing 0
Word Form Text Claculations 3

Top