PopUp form or Splash Screen?

[bronen]

I need urgent help. I have to present something in front of some big people.

I need to create a form that appears on startup that asks for the user to enter information in. My example is "Project Number". Once the information is entered, a command button is clicked to close the form and "pushes" that Project Number to all the other forms and tables that have Project Number as a field. I need step by step on how do to do all this. Please help.

[email removed]

Ben

[MMcCarthy]

I need urgent help. I have to present something in front of some big people.

I need to create a form that appears on startup that asks for the user to enter information in.

This can be done using startup options which you will find under the tools menu.

My example is "Project Number". Once the information is entered, a command button is clicked to close the form and "pushes" that Project Number to all the other forms and tables that have Project Number as a field. I need step by step on how do to do all this. Please help.

Ben what you are asking doesn't really make sense. Firstly, forms don't hold data they merely represent it visually. You can add a value such as project number to the table project table by setting the control source of the field to this field assuming the form is bound to this table. You can't push the data to other fields. Data can be added to tables depending on specified criteria.

Mary

[bronen]

This can be done using startup options which you will find under the tools menu.



Ben what you are asking doesn't really make sense. Firstly, forms don't hold data they merely represent it visually. You can add a value such as project number to the table project table by setting the control source of the field to this field assuming the form is bound to this table. You can't push the data to other fields. Data can be added to tables depending on specified criteria.

Mary

I thought maybe you could do a command button or lost focus or something to have the Project number automatically be assigned to project numbers in other tables.

[MMcCarthy]

I thought maybe you could do a command button or lost focus or something to have the Project number automatically be assigned to project numbers in other tables.

But based on what criteria Ben. How do you decide which records to update. If you want to create new records in each table just to populate the project number foreign key I wouldn't advise it as this will creat a load of blank records.

Mary

[NeoPa]

You could have a Global (Public) variable which could be set and then used by all the other forms.
You may need to provide a trigger routine in the various forms so that they know to update the value after it's been changed.

Think carefully before progressing this way though - I can't think of a situation where this would be a sensible way to approach the problem.

You're probably looking at filtering the other forms based on the value set in your main form. This is quite different.
See (Example Filtering on a Form.) for further info and help on this subject.