Display record from a different form on a new opened form.

[Emmanuel]

Am trying to do something on access and am kind of stuck.



I have two forms with names
1. Salary
2. Calculation

The form salary has a field named “basic” which stores the basic salary of an individual in a linked table.

I have created an after update event which opens the form “Calculation” (while the form “salary” remains opened) when the basic is entered.

Calculation has two fields on it called “basic” and tax”
Calculation is also linked to a separate table where the data is stored.

What I want to do is, if I entered say 2000dollars in the basic, automatically the calculation form will open but I want the 2000dollars to be the amount appearing on the basic field of the calculation form.

Currently, am able to open but only custom basic can be entered.
Any help with this will be greatly appreciated

[davegri]

Check out the 'openargs' parameter in docmd.openform

[Micron]

I might hide the first form and just refer to the other form and its field, then don't show the 1st form until the 2nd is closed. That will prevent anyone from being able to alter the 1st form after the 2nd's field has been set. Since you'd have to set the form2 field value to open args (e.g. Me.myField = Me.OpenArgs) you could write
Me.myField = Forms!1stForm.myField.
Usually, many ways to do the same thing. My point is just that, and hiding the 1st form until it's safe to show it again (or just close it if that's what you want to do when 2nd form opens).

[Emmanuel]

Am kind of lost. Would be glad if I get a practical demonstration of it.

Like an example to make it easier for my my understanding.

[davegri]

OK. In your after_update event in form Salary that opens form Calculation,

Docmd.openform "Calculation",,,,,,me.basic

Aove me.basic refers to the control (textbox, combobox, etc) that holds basic in form Salary

Then in form Calculation in the Form_Load event,

Me.basic = openargs

This me.basic is the control (textbox) in form Calculation that you want to receive the openargs data.


This is one method that allows you to pass information from one form while opening another form.

[Emmanuel]

OK. In your after_update event in form Salary that opens form Calculation,

Docmd.openform "Calculation",,,,,,me.basic

Aove me.basic refers to the control (textbox, combobox, etc) that holds basic in form Salary

Then in form Calculation in the Form_Load event,

Me.basic = openargs

This me.basic is the control (textbox) in form Calculation that you want to receive the openargs data.


This is one method that allows you to pass information from one form while opening another form.

I tried your code.
And the basic was able to display on the calculation field as requested.

But there was a little issue.
I applied an after update event to the basic field of the calculation form.

But when the basic appears on the calculation form, the after update event on the form doesn’t take effect unless I manually type the basic again before the after update event takes effect.

Is there any fix to this?

[davegri]

But when the basic appears on the calculation form, the after update event on the form doesn’t take effect unless I manually type the basic again before the after update event takes effect.

Is there any fix to this?

Updating the basic field with code will not fire the after_update event, as you've discovered. Perhaps you can add a button to the form. The button on_click event can call the after_update event.

[Emmanuel]

Updating the basic field with code will not fire the after_update event, as you've discovered. Perhaps you can add a button to the form. The button on_click event can call the after_update event.

Have able to find a fix.
I applied my code on the “On Got Focus” event and it worked

Thanks to you all

[Emmanuel]

I know this chapter is closed but I have another question that has a link with this post.

Using the same form names, if I have two fields called start_date and end_date and I want to use the openargs to display the output on a report where both start date and end date will appear on the report, how will I do that?

[orange]

I suggest you post a copy of your database(zip format) with only a few records to highlight your requirement and expected output.

Where are if I have two fields called start_date and end_date?

[Micron]

Easier to have the report pull those values from the form, I'd say.

If you must use open args, pass a comma separated string (e.g. 1/1/2022,2/2/2022) and use the split function to separate them into values. If you try to pass the values as dates (#1/1/2022#) I think you'll find that the dates will be converted to a string anyway. So if you need date data type values, openArgs just makes this more difficult than it has to be.

EDIT - best case is that the date fields are in the query that is (should be?) the recordsource for the report.

[Emmanuel]

Interesting. Maybe I will have to think about another way out without openargs

[Emmanuel]

I suggest you post a copy of your database(zip format) with only a few records to highlight your requirement and expected output.

Where are if I have two fields called start_date and end_date?

Will try and do that

[Emmanuel]

Have been able to find a fix. Thanks so much for your time