Form Records

[_Otacustes_]

Hi,
I have many forms which I have designed to be as idiot proof as possible howver I have one problem which is prooving difficult to solve.

When the forms open, records are attached to bound text boxes, list boxes etc. The problem is that when a form opens it should display one record only but using the scroll wheen on the mouse, the tab key and others, a user can navigate to other records. I have disabled the record selectors on each page along with the navigation buttons.

Is there any way of stopping other records from being displayed?? Any help is much appreciated.

Thanks

Ota

 

[dopedealer]

Use Dlookup.
(DLookup Syntax - DLookup("[Field Name]","Table Name","[Field Name to Filter On] = " & FilterVariable/Form Control)
Dlookup can either be placed in the contol scource of the text boxes you are using to display the corresponding records or in VBA, make sure you make a query with all the fields from the table you want displayed and in the criteria base it on the current form.
Chris

 

[ghudson]

Set the Forms "Cycle" property to "Current Record".

This might be of interest to you... A better mouse trap?

 

[dopedealer]

Set the Forms "Cycle" property to "Current Record".

This might be of interest to you... A better mouse trap?

Out of curiosity, does this method work for all known interfaces? Eg. USB, Serial E.T.C.

Chris

 

[ghudson]

I am not familiar with external devices.

Are you referring to my Mouse Trap method?

 

[_Otacustes_]

Thanks all for your replies - they are most helpful

This will give me something new to look into and learn!!

Thanks

 

[dopedealer]

I am not familiar with external devices.

Are you referring to my Mouse Trap method?

Yes, i was wondering if your method worked with both USB and Serial Port Mouse ports.
Chris

 

[ghudson]

It should with any type of mouse connection. I have a USB at home and a serial at work and I have never noticed any differences. The code is really trapping the "dirty" event of the record and any attempts to move off of the current record if it is dirty, no matter how the user attempts to move off of the current record. Did you try my Mouse Trap sample?

 

[dopedealer]

Very Nice, you should have sold it for a million dollars to someone
Just tried it now.
Chris