Selecting Family Members

[Whispersplus1]

I'm trying to create a form in Access 2007 that will allow my to select a family member using a combo box. After I select the name I want the attached subform to reflect the correct information. In this case all the articles located in the building for that person. Please HELP.

 

[iankerry]

have you tried looking at the northwind database - the sample that comes with access? They use this (i think ) on the orders form. You'll be able to work it from this.

If you dont have it it is available for download, just google it.

Ian

 

[Whispersplus1]

I have attached an example of what I want the form to look like. What I want it to do is giving me alot of trouble. When you click on the form it should ask you once WHICH BOX #. After your type the box in, the family members in the box should be listed in the combo box. When you select a family member it should update the subform to reflect the packages on hand for that person. PLEASE HELP ME......

 

[iankerry]

Hi

Not sure I can help as I am quite a novice.

Where is the problem exactly?

When you are asked for the box # - what do you type in? I am assuming you type in for example 0011 and not 11?

ian

 

[Whispersplus1]

Is true, all box numbers are 4 digits. After the information is retrieved I want to be able to select one of the family members. By selecting the family member it will automatically update the subform that is attached to reflect information about that family member.

 

[lcook1974]

I don't have Access 2007...but it sounds like you need to have your subform based on the Unique value in your combo box.

Can you save it as a 2003 format so I can take a better look?

 

[leem888]

Not sure what your intent was with the Box # field and continuously prompting for that value, but the list below should help you get the combo box and subform working.

1. add CustomerID to your comboBox Row Source query.
2. if CustomerID is your first column, make sure to change the Bound Column property to 1 versus 2
3. change the Column Count property from 1 to 2
4. change the Column Width property from blank to 0;2
5. under the subform selection, Link Master Fields property change CustomerID to File As

I hope that helps.

 

[Whispersplus1]

I appreciate all the assistance and a special thanx to leem888 for trying to simplify some instuctions for me but, I'm still having difficulty getting the form to do what I really want it to do. In the attachment there are to forms, the first one "ACustomers Extended" the results I'm looking for are correct, only the method is wrong. How can I get the form "ACustomers Extended1" to come up with the same results using a combo box instead of a table at the bottom of the form?

Thank you in advance.

 

[leem888]

here is the version I edited yesterday. I removed the box # field. nevertheless, is this what you were trying to accomplish?

 

[Whispersplus1]

Thank you so much......
The version you edited is almost exactly what I'm looking for. All I need to do now is figure out why I have to enter the box # twice to get what I want it to do. If you have an idea I'm all ears?
If it's too much I'll understand?

 

[leem888]

If I remember correctly, in the "extended" query, you are prompting for the [Enter Box#]. So each time you execute the query, it will prompt you for the value.

Just a thought, but have you considered creating a comboBox for the Box #, and as you change between that, the comboBox for the employee name will refresh with a different list, and as you change that one, it will change the subform records. Just a thought?

 

[Whispersplus1]

Combo boxing the Box# isn't going to really help me. (way to many boxes) I would like whatever it takes to go directly to the Box# giving me an option of the family members displayed in a combo box or list from which I can choose the person I'm really looking for,(without re-typing the box number) resulting in the subform updating itself with the correct information.
Is this at all possible?

 

[Whispersplus1]

I figured I'd share the end result, it still needs a little tweeking but, its' doing what I wanted. Again, thanks to all that tried or did help.
P.S. If you find a way to get the parameters box to show by hitting next without having to click on the arrow, please share.