Form Issue

[adigga1]

Hello Again,

Earlier I posted a copy of my Database for help in solving a Form issue,
the advice I got helped alot and I got the Form to Function with A Single Table,(Patient -Case 2) But someone told me to Normalize and Split the Tables in two,(Patient -Case 3) so I did but I'm having a very had time duplicating the Form operations as the previous one with the Single Table. I would like to go with the Patient -Case 3 in order to avoid issues down the road. I have included both versions of the Form in 1 zip file. Please Help and feel free to make changes to them to illustrate. I"m going nuts with this I'm also still on a learning curve, so please bare with me?

Previous Post Message: "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)"


Thanks for your patience in this.

Regards,
A...

[tuxalot]

edited post - didn't understand question

[NeoPa]

I'm sorry but this question is too unclear for me even to be able to change the invalid title to a valid one (Please see Use a Good Thread Title) :S

You also need to consider that it is important to express you question clearly in words. Attaching databases (true for most attachments) should only be considered when requested. It is not an alternative to expressing the question properly in the first place. Later, if asked, it can be considered as extra information.