Opening a Form from two places...

[Nightowl4933]

I don't think that will make any difference. I think I need to see the database to figure this out.

It might be a bit much to ask, but I could send it to you - I would ask you not to give it to anyone else though, please?

Or be too amused at my efforts

Pete

 

[Gasman]

If you look at the OP's code you see that that would be quite a bit of information to include in the OpenArgs. I suppose he could concatenate it together in a string, delimit it with commas, and then use the split function to sort it out in the form open.

Only 9 small values?

That is the route I would take just to save the bother of maintaining two sets of identical (well meant to be) code.

Perhaps there is a better approach to stopping users editing a record which is being viewed elsewhere?, writing the id to a temporary table or some such method.?

 

[Nightowl4933]

Hi guys,

Thanks for all your advice and comments on this.

Rather than using the On_Click event on each of the forms, I'll use the On_Load event of the 'slave' form (thanks sneuberg ) to set the form up.

(This) problem solved

Pete