open pop up form using anothers forms name as the criteria

[roosn]

okay, i have presented my database to my boss.

apart from the ongoing problem of trying to get a listbox and subform the same to the user, he has asked me to do something more

he wants me to be able to select from the menu, a selction that will open up a pop up form, from which notes can be made relating to the originating form

i presume the linking criteria will use the form name plus the record criteria the originating form is bound to

any help on how i go about this will be greatly appreciated

 

[dionem]

Hi,

The way i have done that in my databases is as follows:

On the original form:
When i select an item from my combo box it populates (using an after update event) a label with the ID that i have created which is not visible in form view, using the following code:

Private Sub cmb_SiteList_AfterUpdate()
lbl_name.Caption = cmb_name.Text
lbl_ID.Caption = cmb_ID.Value
End Sub

Then i have based the subsequent form on a query which looks up the ID that the label has been populated with by having in the criteria for the ID field:

[Forms]![frm_01_formname]![lbl_ID].[Caption]

Hope this helps

 

[RuralGuy]

If you are using ac2K+ then look into the WhereCondition and OpenArgs arguments of the OpenForm command. There is no reason to reach back into the previous form.

 

[roosn]

thank you for your help on the opening the form, much appreciated

any ideas on the user interface issue, so the user can use a list box and / or sub continuous form, without knowing or wanting to know about the design difference

 

[RuralGuy]

You're welcome roosn. As for the user interface issue, here's a link to the other thread for those who have not been following. I really have nothing to offer except that I would expect it to take a lot of code to make one type of control look and feel like another type of control, if it is even possible. They are different controls because they can perform different function and do them differently. If someone is willing to pay you to make them look and feel the same then the more power to you.

 

[roosn]

in essence, if i could get numeric values to align to the right of the listbox column, then it is problem solved,

at the moment it appears as:

20,000
4,000
200
90

which obviously appears difficult and confusing to look at, with lots of rows

 

[RuralGuy]

Maybe Stephan Lebans can assist here! http://www.lebans.com/justicombo.htm

 

[roosn]

Thanks for the link Rural guy, great solution to my problem