How do I automatically display contents of a field in a form?

[AnnaZ]

Hi,
I have a table with fields - Client ID and Funding Source. These fields are already filled in. I created a form where users can enter some additional information for each Client ID. What I'm trying to do is when that form is opened and Client ID is selected, I need the input box that holds the Funding Source field display whatever is entered in that field for that Client ID.
I was wondering if anyone knows how this can be done in Access? Any help would be greatly appreciated. Thanks in advance.

 

[KeithIT]

Create a query that links the information through the ClientID, and then link the field to ClientID using that query. Is your form based on the a query? Often times for a simple form like this the best thing to do is just base it on a query that contains all of the fields that you need, set up your conditions in the query and then have the form display the fields that you need from that query.

How are you having your end user access the ClientID?

 

[KeithIT]

Create a query that links the information through the ClientID, and then link the field to ClientID using that query. Is your form based on the a query? Often times for a simple form like this the best thing to do is just base it on a query that contains all of the fields that you need, set up your conditions in the query and then have the form display the fields that you need from that query.

How are you having your end user access the ClientID?

 

[KeithIT]

Create a query that links the information through the ClientID, and then link the field to ClientID using that query. Is your form based on a query? Often times for a simple form like this the best thing to do is just base it on a query that contains all of the fields that you need, set up your conditions in the query and then have the form display the fields that you need from that query.

How are you having your end user access the ClientID?

 

[KeithIT]

Sorry!

Sorry about that. I didn't mean to post that reply three times, my network at work is a little loopy today. Sorry!

 

[AnnaZ]

KeithIT, thank you very much for your help.
My form is actually based on a table.
What happens is that I have a form that contains client ID and client names as a drop-down, these come from one table, let's call it Table1. There's also a sub-form that is linked to the main form through the Client ID. Whatever Client Name the user chooses from the drop down, that client's Client ID appears in the sub-form. The sub-form is based on a different table, Table2. The sub-form is where the users enter data and it goes to Table2.
The Client ID is linked from Table1, so it appears automatically in the sub-form when the user chooses it from the drop-down that's contained in the main form.
Now, what I'm trying to do is have the contents of the Funding Source field, which is also in Table1, to automatically appear in the sub-form. Is there any way I could do it without creating the queries, but with the tables? I have it already set up working with some other forms and tables and wouldn't want to redo the whole thing completely. Are there any settings where I could point this Funding Source field to Table1 (and display the contents of the field), where the rest of the form goes to Table2?
I know this might sound confusing. Please let me know if you have any ideas or suggestions. thanks a million!

 

[KeithIT]

Okay, if my understanding is correct you have the field in the parent form already set up to display the field from the table. You would like the same field from that table to also display on the child form? Is this accurate? If so, then you can either bind the field in the child form to the same field in the table (i.e.: frmParentForm.txtText1 is bound to tblTable1.chrField1, then simply do the same for the child form, so that frmChildForm.txtText1 is bound to tblTable1.chrField1), or set the field in the child form equal to the field in the parent form (so that the default value of the field in the child form is set to read from the parent form). If i understand your structure correctly, this second option might be the smoothest way to accomplish this.

I'm not sure if this makes sense or how proficient you are with access in terms of doing these things. Let me know if this help or if my understanding of the issue is way off base.

 

[AnnaZ]

KeithIT, thanks again!
Yes, I do have a field (ClientID) in the parent form set up to display the field from the table. this same field (ClientID) is also set up in the child form. Whatever ClientID that is selected in the parent form, that same ClientID appears in the child form. By the way, the child form goes to a separate table. Ok, so this part works.
What I'm trying to add is another field, Funding Source. Each ClientID also has a funding source, which comes from the same table the parent form is linked to. Currently, I don't have the Funding Source field displayed in the parent form, and actually, I don't need it there.
So, how I need this to work is whenever someone selects the ClientID from the parent form, that ClientID is displayed in the child form (this part works) and ALSO, the Funding Source should be displayed in the child form.

How would I set the field in the child form equal to the field in the parent form? Does that field need to be displayed in the parent form or it can just come from the table that the parent form is linked to? If it needs to be displayed, can I just make it invisible?

Thank you very much for all your help!!