Help with Combo Box getting my member information, then displaying the Dues detail

[ballj_35]

Hello everyone,

I am using Access 2010, 64 bit on Windows 7. I am going to detail my challenge and hopefully someone can direct me to help me understand how to get this done.
I have created a Member Table and a Dues Table. This is a 1 (Mbr) to Many (Dues) relationship.

1. When I wish to Add Dues, what I have created so far is a form, where there is a Combo Box in the form Header to get a list of members
from the Member Table, using the Mbr_Bond_Number and Mbr_Last_Name to ensure they grab the valid member.

2. Now when they select the record they want, what I need to do is take the MBR_Bond_Number & MBR_Last_Name and move it to the form
in the detail portion of the form. This way, the user cannot enter a Bond Number that does not exist in the Member Table.

3. On the Dues Table, the field is DUES_Bond_Number and in the Member table, it is MBR_Bond_Number. When the user selects an
entry from the combo box, how can I get the MBR_Bond_Number to the DUES_Bond_Number. Then when they click on Save, I have the
key values set correctly.

4. I will make the DUES_Bond_Number protected on the screen, this way the user cannot enter a value on the screen.

Any help & direction would be greatly appreciated and thanx in advance.



Jerry

[June7]

Use a form/subform arrangement. Review http://office.microsoft.com/en-us/ac...010098674.aspx

Do not save the member name to dues table, just the primary key from members table should be saved as foreign key in dues table. The form/subform arrangement will synchronize the related records and automatically save the key in dues table.

[ballj_35]

June7,

I have read this, but can I make the Main Form a Control Box to just select the records from the Member table and then addd information on the Dues Table?
I created the relationship already, per the documentation. I will look into this further.
Thanx.

Jerry

[June7]

Here is another tutorial you might find helpful http://datapigtechnologies.com/flash...tomfilter.html

[ballj_35]

June7,

I have gotten it to work and it looks great. I Thank You so much. The only issue I am having now is when I click on the Undo button, it does not work. I have tested the "Save" Button and it works fine, but cannot get the undo to work. I am getting, "The command or action is unavailable". Any ideas?
Thanx in advance.

Jerry

[June7]

Show the code for the Undo button. Or provide your project for analysis. Follow instructions at bottom of my post.

I actually have never been able to get 'Undo' to work but maybe I will have better luck with your db.

[ballj_35]

June7,

I have gotten it work. What you have to do is put the buttons in the Form Header of the SubForm and it works like a charm! Thought about this for a while and then got up and tried the code. Used the wizard to create a button and followed the steps. Here is the code for the macro anyways:


RunMenuCommand
Command UndoRecord

Thanx for all of your help! I really appreciate it.

Jerry