bookmarks not working help!

C

Curt

I have a form with a query as the recordsource. In this
query I have a concatenated field. This form has a
subform which is related to the form linking to this
field. This all works fine, but I thought I would throw
that in just in case the answer to my question might cause
other problems.
Anyway I have an unbound listbox on my main form. This
list box is updated when I select items from the main form
and the subform. This list box also has the field from
the concatenated field(hidden). What I am trying to do is
select a row (person with items related to that person)
from the listbox to bring up their record on the main
form, in case users need to update their record. How do I
go about doing this? I have looked up bookmarks and
recordsetclones, but I still have not got anything to work
for the past 2 days since I am selecting a string.

Any help would be appreciated
 
H

Howard Brody

When you select a person in the ListBox, filter the main form for the selected person. If the subform is tied to whoever's displayed in the main form, it should change with it


----- Curt wrote: ----

I have a form with a query as the recordsource. In this
query I have a concatenated field. This form has a
subform which is related to the form linking to this
field. This all works fine, but I thought I would throw
that in just in case the answer to my question might cause
other problems.
Anyway I have an unbound listbox on my main form. This
list box is updated when I select items from the main form
and the subform. This list box also has the field from
the concatenated field(hidden). What I am trying to do is
select a row (person with items related to that person)
from the listbox to bring up their record on the main
form, in case users need to update their record. How do I
go about doing this? I have looked up bookmarks and
recordsetclones, but I still have not got anything to work
for the past 2 days since I am selecting a string

Any help would be appreciate
 
C

Curt

Ok, I thought about that and even tried to do some
research on it. However, I am still stumped on how to
make this happen. Any ideas?

-----Original Message-----
When you select a person in the ListBox, filter the main
form for the selected person. If the subform is tied to
whoever's displayed in the main form, it should change
with it.
 

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

Top