access thread: Show values in text boxes instead of data grid?
Message #1 by "chris angus" <chris@a...> on Fri, 26 Oct 2001 09:17:54
|
|
Can anyone tell me if there is a bit of code for the following
txtpart.text = data1.recordset field a1 where field psupp = 'EA'
The reason is
data1.recordsource = "SELECT * FROM PRICES WHERE SUBKEY = '" _
& data2.recordset!id & "'"
This shows three records for each id, but I want to show the
values in text boxes and not in a data grid
Any help appreciated.
Message #2 by Lonnie Johnson <prodevmg@y...> on Fri, 26 Oct 2001 05:59:44 -0700 (PDT)
|
|
Is your "grid" in Visual Basic or Access? If it is in Visual Basic you can assign text boxes instead of a grid and assign them
values from your query/table.
chris angus <chris@a...> wrote: Can anyone tell me if there is a bit of code for the following
txtpart.text = data1.recordset field a1 where field psupp = 'EA'
The reason is
data1.recordsource = "SELECT * FROM PRICES WHERE SUBKEY = '" _
& data2.recordset!id & "'"
This shows three records for each id, but I want to show the
values in text boxes and not in a data grid
Any help appreciated.
|
View Cart
