Help, please.
I need to display about 8 or 10 records in a query simultaneously on screen using forms. I cannot use continuous forms as I need each record and therefore each form ordered VERTICALLY. There will need to be some user interaaction to each form. For clarity, this is a restaurant kitchen screen displaying multiple current orders so a kitchen staff would need to see the order and then interface to say when the order is cooked/prepared.
I have tried using each of the 8 or 10 forms as subforms on a main form and then use the gotorecord command to toggle each form to its desired record number. However, once embedded as subforms an error is returned indicating that the form isnt open thefore the macro halts. I use a macro to drive the gotorecord command.
I am considering using multiple individual forms but the problem I would have then would be positioning the forms correctly so there is no overlap, no maximising or other distortion of the positions of each form etc. As I mentioned, other users need to use the interface so I fear they will click or move the forms out of place.
Is there an easy way to have multiple subforms on one form? Or would I need to go to the multiple form solution and use code to position each form separately on the screen? If so, how do I account for varying screen resolutions on different computers???
Thanks in advance..