Set Value problem

[jhcarrell]

I've created a database that allows for multiple instances of a form (see http://allenbrowne.com/ser-35.html).



However, I've ran into a small snag with a command button I'm using on this form. The button was created with a click event macro that does the following:

Makes select objects visible
sets time field to Time()
sets date field to Date()

If I open the form manually from the navigation pane, all works as intended, but if I use the multiple instances function I receive this error:



This is happening because of the Set Value functions of the Macro as it is not recognizing the multi-instance form.

Can anyone suggest a workaround for this issue?

Any help is greatly appreciated.

Thanks.

[jhcarrell]

I've created a sample db to demonstrate the issue I'm running in to.

Click > Single instance > everything works.

Click > Multi-Instance > button makes field visible but doesn't set value.

I'm wondering if I could use a module to set value and make the field visible instead ...

Again, any suggestions would be greatly appreciated.

Thanks.

[jhcarrell]

Received a suggestion on UtterAccess to try using VBA instead of the macro and it worked like a charm.

Solution:

Use VBA click event to set visibility and value.