Desperately Need Help with List box or combo box

[Guest]

I am sorry to say that I can't get my list box to work by synchronizing it
with my other two subforms. After following instructions below I still can't
get my list box in synch with my other two subforms. I went to the website
and the item mentioned does not show the form. I just want to be able when
clicking on a name in the list box for the details of the information to show
in the subform and the members of this group to show in the second subform.
Can you please help or can you direct me to a simple sample. I rather not
use code if possible as I am not at all a code user. Thanks in advance for
any help.


Binding, yes. Synchronizing, you really need code, but it's one simple line:

 

[Brian Bastl]

TotallyConfused,

I'm willing to take a quick look at your db. You'll first need to convert it
to A2K or earlier format, compact it, and then Zip it up. I should be able
to get to it later today.

Brian
NobastelSpam<at>alltel<dot>net
remove No and Spam and convert <at> and <dot>

I am sorry to say that I can't get my list box to work by synchronizing it
with my other two subforms. After following instructions below I still can't
get my list box in synch with my other two subforms. I went to the website
and the item mentioned does not show the form. I just want to be able when
clicking on a name in the list box for the details of the information to show
in the subform and the members of this group to show in the second subform.
Can you please help or can you direct me to a simple sample. I rather not
use code if possible as I am not at all a code user. Thanks in advance for
any help.


Binding, yes. Synchronizing, you really need code, but it's one simple line:

If the listbox is in the main form and you are syncing a subform:

Sub lstBoxName_AfterUpdate()
Me.NameOfSubform.Requery
End Sub

Use a query as the RecordSource for the subform. Take the field in the query
that you want to sync and use the criteria box to Build a criteria:

[Forms]![FormName]![ListboxName]

I have a sample using mulitple list boxes at the AccessMVP.com website:

 

[Guest]

Thank you Brian, I got it to work. I appreciate your offer. Had to walk
away from it all for a while came back and redid the box. Working just fine.
Thank you again.

TotallyConfused,

I'm willing to take a quick look at your db. You'll first need to convert it
to A2K or earlier format, compact it, and then Zip it up. I should be able
to get to it later today.

Brian
NobastelSpam<at>alltel<dot>net
remove No and Spam and convert <at> and <dot>

I am sorry to say that I can't get my list box to work by synchronizing it
with my other two subforms. After following instructions below I still can't
get my list box in synch with my other two subforms. I went to the website
and the item mentioned does not show the form. I just want to be able when
clicking on a name in the list box for the details of the information to show
in the subform and the members of this group to show in the second subform.
Can you please help or can you direct me to a simple sample. I rather not
use code if possible as I am not at all a code user. Thanks in advance for
any help.


Binding, yes. Synchronizing, you really need code, but it's one simple line:

If the listbox is in the main form and you are syncing a subform:

Sub lstBoxName_AfterUpdate()
Me.NameOfSubform.Requery
End Sub

Use a query as the RecordSource for the subform. Take the field in the query
that you want to sync and use the criteria box to Build a criteria:

[Forms]![FormName]![ListboxName]

I have a sample using mulitple list boxes at the AccessMVP.com website:

 

[Brian Bastl]

Glad you got it figured out.

Brian

Thank you Brian, I got it to work. I appreciate your offer. Had to walk
away from it all for a while came back and redid the box. Working just fine.
Thank you again.

TotallyConfused,

I'm willing to take a quick look at your db. You'll first need to convert it
to A2K or earlier format, compact it, and then Zip it up. I should be able
to get to it later today.

Brian
NobastelSpam<at>alltel<dot>net
remove No and Spam and convert <at> and <dot>

I am sorry to say that I can't get my list box to work by

synchronizing
it

with my other two subforms. After following instructions below I still can't
get my list box in synch with my other two subforms. I went to the website
and the item mentioned does not show the form. I just want to be

able
when

clicking on a name in the list box for the details of the information

to
show

in the subform and the members of this group to show in the second subform.
Can you please help or can you direct me to a simple sample. I rather not
use code if possible as I am not at all a code user. Thanks in

advance
for

any help.


Binding, yes. Synchronizing, you really need code, but it's one

simple
line:

If the listbox is in the main form and you are syncing a subform:

Sub lstBoxName_AfterUpdate()
Me.NameOfSubform.Requery
End Sub

Use a query as the RecordSource for the subform. Take the field in

the
query

that you want to sync and use the criteria box to Build a criteria:

[Forms]![FormName]![ListboxName]

I have a sample using mulitple list boxes at the AccessMVP.com website: