SQL and Getting Data From Another Form - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

SQL and Getting Data From Another Form

Colin Eastaugh

3 months ago

Two forms.

In FormA

I have a button that sends data from a label called "Tick" and puts it into label "TickZ" in FormB

DoCmd.OpenForm "FormB", , , acFormEdit
Forms!FormB!TickZ = Tick

In FormB I use the On Load command to run an SQL procedure that selects records from a table.  The WHERE statement doesn't seem to recognise the information contained in label "TickZ". (I have also used On Current and On Open, but with the same result.)

I have had to include a button on FormB to action the WHERE part of the SQL procedure.

It would appear that when FormB is loaded, the transfer of data from FormA into FormB is ignored. (When I am in FormB I can see the information transferred sitting in TickZ.)

Is there a way of avoiding the extra keystroke?  Thanks.

Donald Blackwell @Reply

3 months ago

First, the command you typed is missing a comma, acFormEdit is in the where condition spot, so if that's not just a type where you copied it to the forums, that could be what is preventing your other code from running. [FormName], [View],[Filter],[Where],[WindowMode],[OpenArgs]

Otherwise:

You could include "Tick" in OpenArgs for your form open and then check that in the form load event.

For example:

DoCmd.OpenForm "FormB", , , , acFormEdit, , Tick

Then in the form_load:

If Not IsNull(OpenArgs) Then

   DoAction OpenArgs

end if

Replace DoAction OpenArgs with whatever you're trying to do

Richard discusses OpenArgs in Custom MsgBox 2

Colin Eastaugh OP @Reply

3 months ago

Donald

I'm feeling a tad emotional.

You are a star. Today is not wasted because of your speedy response. OpenArgs have entered my life. I'm sure that I'm going to have to get to grips with TempVars one day, and I really need to set some time to one side to understand Recordsets and Recordclone, I really should have them in my Access toolkit, but on this Sunday I'm very happy that you have brought OpenArgs into my life, and I no longer have to press two buttons going forward.

It may be half a second you have saved me but the aesthetic pleasure is immense because the database will really fly going forward.

Thanks again.

Colin

	Donald Blackwell @Reply 3 months ago
Glad to be of assistance. Where OpenArgs really shines is if you open a form as a Dialog because as soon as it opens, all code in the form that opened it stops until the Dialog form closes so it helps you to get info passed easily.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View