Newbie Questions....

Tazzy1972

Hi all,

I have a main form with a subform. The List function lists out all records in the main form source table. Can I change that to List the records on the Subform source table instead?

Also, if I want to open another form from a form and have the 1st form updated with the parameters from the 2nd form, what are the codes needed? The 2 forms have different source tables.

Thanks

Tazzy

jyotsnas

Hi Tazzy

Case 1:
For changing the list form that is displayed
Go to the form designer. For the List menu item, set action property to runobject and set runobject as form ID that you want to run.

But this way, if you press list button on the tool bar, the form thats set as lookupform of table will be shown. Use your marketing skills and show it as a feature I wont recommned to remove the lookupForm property of source table.

Case 2:
say SourceForm is the form on which you have te parameters set. and TargetForm is the form on which you want the values transferred.

in TargetForm you will have to write a function that will
- accept the values to be sssigned as arguments
- assign the values to the global variables( declared in the targe form that are source expressions of text boxes ) in the function body

In SourceForm, you will have to call this function before running TargetForm. Thats it.

All the Best

Regards
Jyotsna

Tazzy1972

Thanks.... actually wanted to change the List function at the toolbar but nevermind.

jyotsnas

Hi

That is possible by changing LookupFormID property of the table; but it would not be semantically correct.

Regards,
Jyotsna