Need Text box with list box properties

  • Thread starter Thread starter sharontodd
  • Start date Start date
S

sharontodd

I am pulling data up from a table and need a box to show the data from a
specific record and field. I also need to be able to change the data that is
displayed. I can show the data using a list box using the following code in
the row source.

SELECT [Divisions/Winners].First FROM [Divisions/Winners] WHERE
((([Divisions/Winners].[Div #])=[enter data]));

I need to do the same thing only with a text box so that I can alter the
data. Since there is no row source for a text box, how do I achieve this?

Thanks for the help.

Sharontodd
 
Why not use a Combo box. The reason it is called a Combo box is because it
is a combination of a text box and a list box.
 
This may be a possibility. I came up with

= DLookup ("[Second]", "Divisions/Winners", "[Divisions/Winners].[Div
#])=[enter data]"

with the third parameter to choose the record (this matches the WHERE stmt
on the Row Source for the list box that does give me the correct record).
But, where do I put this? I tried under valadation rule but it didn't help.
The form is just incrementing by one each time I enter a value in "enter
data" - I'm not getting the record entered in "enter data".
 
Sounds like a great option. I tried to enter the same row source as I have
for the list box but I am still getting results from incrementing records
starting at 1, not the record being entered in "enter data".

SELECT [Divisions/Winners].First FROM [Divisions/Winners] WHERE
((([Divisions/Winners].[Div #])=[enter data]));

Also, can I get rid of the drop down arrow at the right of the box. I just
want to show the value in that record and allow the user to enter a new value
in that field for that record.

Thanks.

sharontodd


Klatuu said:
Why not use a Combo box. The reason it is called a Combo box is because it
is a combination of a text box and a list box.
--
Dave Hargis, Microsoft Access MVP


sharontodd said:
I am pulling data up from a table and need a box to show the data from a
specific record and field. I also need to be able to change the data that is
displayed. I can show the data using a list box using the following code in
the row source.

SELECT [Divisions/Winners].First FROM [Divisions/Winners] WHERE
((([Divisions/Winners].[Div #])=[enter data]));

I need to do the same thing only with a text box so that I can alter the
data. Since there is no row source for a text box, how do I achieve this?

Thanks for the help.

Sharontodd
 
Back
Top