Continous Form (like Property Sheet entry)
Daft question time!
The application I am developing needs to have a form where entry is a bit like a Property Sheet, continuous, left column read only, right column different type of entry could be freeform text, numbers, a date, a drop down box with different list values, etc depending on the current record.
Now I know you can't manipulate the current record by making controls visible etc without affecting the non-current records, so I can't do that. Neither can I create controls dynamically.
The number of records will vary, I suppose I could create a single form with lots of controls and only activate dynamically what I need, but this would put a restriction on the number of records that could be held.
I have tested (not completely) a floating input form that covers the entry on the form to be updated. It moves with the current record and looks good, however when the Access window or form moves sync is lost as there is no Move event. Also scrolling the current record out of view causes issues (Now sorted using a function in Timer). It's not really a good solution and I don't want to put more effort in until I can get some clarification I am going down the right path and may be missing a trick or two.
Any ideas would be appreciated or should I develop in Visual Basic instead?
Last edited by malcolmdixon; October 19th, 2010 at 10:10 AM..
Reason: Solved part of issue myself