Is there any process to calculate the value automatically in a form field when Access

[rahul90]

I want to query a filed of a table which is updated by a calculated filed of a form. but every time i have to open the form before i run the query. because the calculation programmed on form load.
Is there any process to calculate the value automatically in a form filed when access opens.??
thanks!

[jimatqsi]

If you look in the Access Options for "current database" you will see that the database can automatically open a form when the database loads. It's as simple as that.

Jim

[hvsummer]

give jimatqsi the best answer, you just have to pick a form load at access startup in access current client option.

[rahul90]

Thanks.
But i don't want to load that form at start up. I made a switchboard for that and other forms . so its necessary to load that switchboard first.

[Hat2boots]

In a Macro Open the Form in Hidden mode then run the Query and then close Query and Form. Then your Trigger is the Macro.

Is that the direction you was wanting?

[zmbd]

rahul90,
It's rarely a good idea to store a calculated value unless needed for something along the lines of an audit trail, ISO Documentation, or say a one time discounted price that would not normally be provided.

With that said, as Hat2boots has mentioned, the form can be opened in a hidden state. Any value that is calculated on a form either as a local/global or in an unbound control will not be available until the form is loaded. Personally, I would avoid the Access-Macro script language and do this instead via VBA; however, either will work.

Keep in mind, most of us here use VBA for the majority of the non-SQL work unless working with a SharePoint-Application and you will find much more support on the forum for VBA procedures. The Access-Macro language still has significant limitations which is why most of the experts/moderators tend not to use the language unless forced.

[rahul90]

thanks Hat2boots. its relay a helpful idea. and thanks zmbd for your valuable suggestion.

Thanks a lot.

[Hat2boots]

Okay I admit it, I am a Newby. I have been trying VBA, but at this point for me, the Macro was a little more intuitive.