Data Alignment issues in a Form

[Adigga1]

Hello everyone,

I am using Access '03 and I have included a copy of my database with test data included.

The Issue:

I have a Form (F_Payments), and my control field is the Case MRN:. What I'm trying to accomplish is this;

When I select a Case MRN from the drop down, I want to be able to enter my data into the fields to be saved in the table of the target Case MRN which is the AcctNum in the Table (T_Patient).

When I want to make a change or entry to the fields associated with the Case MRN: on the form, I should be able to simply select the Case MRN (AcctNum) and all the data should reappear and whatever changes I perform should save back to my table.

Problem:

1. What actually occurs is when I select the Case MRN, it doesnt always line up correctly and I have to select it again to get the correct Case MRN (AcctNum)

2. The data that is being written back to the table are inconsistent; such as, the Expected Reim Date: and Variance: calculated fields which have to be saved for future reporting.

Can someone please assist with this issue

Thank you in advance

A....

 

[boblarson]

Well, it is pretty obvious in that your table is bound to the form and so any changes you make will be done at that record. The combo box is bound so any "selections" you make are just changing the data for the record you are on. It isn't a search to find an existing record. if you want that then you need to add a new combo box that is UNBOUND (in fact the wizard will do the work for you if you select the THIRD option when you add a new combo with the wizard).

 

[boblarson]

And on another note, this is not a relational database but a flat file and it really needs to be redesigned to be a normalized database.

See here for how to normalize:
http://www.accessmvp.com/strive4peace/Access_Basics_Crystal_080113_Chapter_03.pdf

 

[Adigga1]

Well, it is pretty obvious in that your table is bound to the form and so any changes you make will be done at that record. The combo box is bound so any "selections" you make are just changing the data for the record you are on. It isn't a search to find an existing record. if you want that then you need to add a new combo box that is UNBOUND (in fact the wizard will do the work for you if you select the THIRD option when you add a new combo with the wizard).

Thank you Boblarson, I will try that. Because I need it (Case Mrn) to retrieve that record when I make a selection.