What is cleanest method to display a list of selected contacts on a customer form?

[wcook101]

I currently tried a few different things. One was bringing over an entire form as a subform. Looked ugly. So now I think a list box looks good. the trouble now is The contacts in the list box are the same for every customer. Now what am I doing wrong?[ATTACH]

[davegri]

Added criteria to the listbox rowsource.
Added embedded macro to requery listbox for form_current event.

Customer Tracking-davegri-v01.zip

[ranman256]

I would think the tContacts table would have a field CustID
then the subform would be bound to the custID and only show those contacts.

[wcook101]

davegri. First off thanks. It looks good. I understand most of it i just dont get this part "txtCustomerID" Im prompted to enter something as a parameter for the open contacts box. What do I enter here? Because no matter what i enter it just openS a list off all the contacts regardless of the customer ID.

[davegri]

davegri. First off thanks. It looks good. I understand most of it i just dont get this part "txtCustomerID" Im prompted to enter something as a parameter for the open contacts box. What do I enter here? Because no matter what i enter it just openS a list off all the contacts regardless of the customer ID.

Change the name of the text box.

[wcook101]

It was already is named txtCustomerID. Thats was not the problem. Your macro was bad. You had "[CustomerID]=" & [txtCustomerID] it should read ="[CustomerID]=" & [txtCustomerID]
You just forgot the = in front of the statement. I added it and now it works great.
Which lead to a new problem. When it opens the contacts form, it doesnt allow me to add a new contact. Is that because the form is a read only or something?

[davegri]

Thats was not the problem. Your macro was bad. You had "[CustomerID]=" & [txtCustomerID] it should read ="[CustomerID]=" & [txtCustomerID]

Don't know where that come from. No such macro at all in the DB I submitted.

It was already is named txtCustomerID. Thats was not the problem. Your macro was bad. You had "[CustomerID]=" & [txtCustomerID] it should read ="[CustomerID]=" & [txtCustomerID]
You just forgot the = in front of the statement. I added it and now it works great.
Which lead to a new problem. When it opens the contacts form, it doesnt allow me to add a new contact. Is that because the form is a read only or something?

With the new problem, are you referring to your complete DB or my abbreviated DB?
If the complete DB, have you applied my changes? If so, please upload the changed DB.

[wcook101]

Yours. Now the list box works perfectly. I just need to find out why im not allowed to add new records from the contacts form. I could before.

[Mickjav]

on contacts form Change the default =[Forms]![Contact]![CustomerID] To =[Forms]![Customer]![txtCustomerID]

Also you should add a table for the business types and use a combobox

mick

[wcook101]

Thanks Mick.

[Mickjav]

Your welcome I also noticed when you open the contacts screen and add a new contact the list dont update you can do it with a update button or open the contacts form in dialog mode then requery the list.

mick

[wcook101]

Mick, Where on the contact form are you seeing a default value that you describe? No where on any property do i see
=[Forms]![Contact]![CustomerID]

[Mickjav]

in the customerID Field Thats why you can't add a record

mick

[davegri]

Your welcome I also noticed when you open the contacts screen and add a new contact the list dont update you can do it with a update button or open the contacts form in dialog mode then requery the list.

Or just add macro to form_activate event to requery the listbox.

This design has a problem if you simply open the contact form from the navigation pane without the customer form open. You get an error, because the default value for customerID is from the customer form which is not open.
This is OK if you always open the contact form from the button on the customer form.

[Mickjav]

When you are finished with the design open the options

click current Database then untick view navigation pan also to prevent users from viewing the navigation pane untick use special keys but make sure you have a design copy backup before doing it.

mick