Enable/disable navigation button on form load (1 Viewer)

I'm fairly new to Access, so bear with me here..

Basically I want to put a code in the "on load" event of a form that enables or disables navigation buttons based on a value in a table (the table has 1 record and 1 column).

So if the value is "A", I want to hide navigation buttons on load; if it is "B", I want to show navigation buttons on load.

I know I can set this property in each form, but I have a number of forms that I want to configure at the same time.

My problem is that I don't know how to reference the value in the table.

Any help is appreciated

Thanks in advance!

Assuming you are bringing through the A/B value in your form recordset

The code (put in your current event, not load event)

Hi CJ - Thanks for the quick reply!

The A/B value is actually from another table called dbo_config, while the form recordset is a table called dbo_component.

Any ideas?

Thanks

Easiest way would be to use dlookup - you'll need to change naems to suit and this can go in the load event