Call a form from a form in the background (1 Viewer)

[Cedarguy]

Hello,

I'm not a VBA guy and am limited to using access macros. So I'm requesting guidance with the following (if its possible):

The user is on form 1
I need to invoke form 2 invisible to the user after he clicks a button
Fill in certain default values on form 2 and save it

Thanks,

 

[RuralGuy]

Forms are simply windows into table values. Why do you think you need to open another form?

 

[Cedarguy]

Thanks for responding;
There are 2 tables involved (Contact and Task) with a 1 to many relationship, respectively
The Contact form shows all the relevant fields while the tasks (child) appear below over which I don't seem to have any control
If the user wants to schedule a task for the contact, I need to create a task behind the scene; fill in the values and save the task
If there's a better way to do so, I'd appreciate knowing it.
Thanks,

 

[RuralGuy]

You can append a record to a table behind the scenes. Sorry it took so long. The site did not send me notification of your post.

 

[Cedarguy]

Thanks; would that be via an append query? trying this out but having difficulty setting values (via SetProperty); tips would be appreciated.
Regards,

 

[sneuberg]

I suggest trying to create the append query using the query designer and put in form references in wherever you need values from the form. If you keep the form open then you can test your query directly in the designer by clicking the datasheet view or running the query.

I can't think of any reason why you would need to set values (via SetProperty) if you create your query this way.

 

[jdraw]

Do you have a set of predefined Tasks? Can any Task be Assigned to any Contact?

You may actually have 3 tables involved.

Task--->TaskIsAssignedToContact<--Contact

1-----to-->many ...junctionTbl...many<-------1


Is there some other factor(s) involved by which only some Tasks can be assigned to only certain Contacts?