bookmarks not working help!

  • Thread starter Thread starter Curt
  • Start date Start date
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
 
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
 
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
Click to expand...
form for the selected person. If the subform is tied to
whoever's displayed in the main form, it should change
with it.
 
Back
Top