Use combo box to change subform

[JQuinnC]

Access is sentient and annoying me on purpose.

Ok, I'm trying to build a form with a combo box and a button that will change the data in a subform on that form.

Basically, a dropdown box of customer names that will populate the full list of fields when I click the button.

I can make the button take me to a new form, but I have no idea how to change the target to the subform. How do I do this?

I'm pretty beginner at this and it's my first database.

[ranman256]

Usu, the combo changes the master form,the the subForm changes off that.
in the combo AFTERUPDATE event, set the filter..
me.filter= "[clientID]=" & cboBox
me.filterOn = true.

but for subForm,you have to its filter...
me.subform.form.filter= ....

[JQuinnC]

Sorry, like I said, beginner.

I'm not quite sure what you told me to do.

My current code for the button is:


When I click the "View Client" button, the "CurrentClientsView" tab updates, but the subform does not.



Where do I put
me.filterOn = true.

but for subForm,you have to its filter...
me.subform.form.filter= ....
?

[vicsaccess]

I haven't used macros in a while so I'm out of practice but that where clause looks wrong. have you tried a google or YouTube search? there's some pretty good tutorials out there dealing with about anything to do with access. here's one i found that might solve your problem
https://www.youtube.com/watch?v=L8nEFLVMQE8

[JQuinnC]

Not what I was looking to do originally, but it'll work. Thanks!