How do I refresh data on form

[Don]

I have a form showing one record at a time. I have a combo box pointing to a
field in a table linked to a similar field in the table I'm showing data for.
I want to click on the combo box, click on an item in it and refresh the form
with the data from the main table. I've been fooling with this for the whole
day and finally have to ask for help. Any ideas?
Thanks

 

[Ken Snell [MVP]]

There are different ways to do this. Let's start, though, with some
additional information.

Please post the query's SQL statement (or the table name) that is in the
form's RecordSource property. If it's a table name, post the fields that are
in the table.

Please post the values for these properties of the combo box:
Bound Column
Column Count
Column Widths
Name
Row Source
Row Source Type

 

[UpRider]

So you have a form displaying data from TableA. On that form you have a
combo box displaying a field from TableB. You want to select a an item from
the combo box to display a matching record on the form from TableA.
My question is, if a match is always to be found, why not have the combo box
just display the lookup field from TableA? What's the need for TableB?

UpRider

 

[Don]

This is what I wanted and tried originally but couldn't get that to work
either so went to second linked table. How do I select an item in a combo and
have it refresh the form with that record

 

[Don]

Row source-SELECT projstatus.projdesc, projstatus.signed, projstatus.start,
projstatus.todate, projstatus.finished FROM projstatus;
Bound column 2
column count 2
column width 0";4.5"
name cboprojdesc
row source SELECT projstatus.projdesc, projstatus.signed,
projstatus.start, projstatus.todate, projstatus.finished FROM projstatus;

row type Table/Query

 

[Ken Snell [MVP]]

Form's Recordsource:
SELECT projstatus.projdesc, projstatus.signed, projstatus.start,
projstatus.todate, projstatus.finished FROM projstatus;

What is the primary key in the above projstatus table?

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

 

[Don]

Primary key is ID, an autonumber field

Form's Recordsource:
SELECT projstatus.projdesc, projstatus.signed, projstatus.start,
projstatus.todate, projstatus.finished FROM projstatus;

What is the primary key in the above projstatus table?

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

 

[Ken Snell [MVP]]

According to the query that you're using for the form's RecordSource, ID
(the primary key) is not in the form's record set. It needs to be there if
you want to use the form for updating data in the projstatus table.

But, let's start at the beginning. Tell us in words what you are wanting to
do on this form. What data do you want to display? What is the purpose for
displaying the data? How will you use these data? How do you get to this
form (e.g., from another form? from database window?)?

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/