Trying to use a macro to load a form dynamically

[jwill]

Hello,



Windows Vista
Access 2007

This is my first post here and I need a little help. I'm trying to load a form dynamically and it doesn't seem to be working. I'm using the OpenForm macro and in the "Where condition" field I'm using '[Forms]![toddler_times]![student_id]=[Forms]![bathroom_chart]![bt_student_id]'. When the form loads it doesn't load any of the corresponding records (and yes there are records in the table ) Any help would be greatly appreciated.

[pbaldy]

The format is

FieldName = Value

so try

[student_id]=[Forms]![bathroom_chart]![bt_student_id]

Here's the VBA method/syntax:

BaldyWeb wherecondition

[jwill]

Thanks alot Paul I used the VB code and I'm almost there. It's asking me to enter the bt_student_id parameter. I was looking for it to use the value student_id in the first form instead of me having to input it. Any ideas?

[pbaldy]

Either that form isn't open or the form or control names are misspelled.

[jwill]

IT WORKED!! I was referencing the control on the form rather than the column in the underlying table. Thanks so much! Will the same method work on subforms?

[pbaldy]

You can refer to a subform for the value, sure. You can't filter one that way, if that's what you mean.

[jwill]

Yes that's what I meant, but that's ok, I'll stay away from the subform. Thanks again

[pbaldy]

Happy to help.