Autofill

[Adsso]

Hi Guys,

I'm really sorry to ask this from my last post I have sort kinda figured out where I'm going and what I need to do but here is a brief run down.

I have 4 tables

tblagents - which contains all my employees information
tblarea - which is where requests are sent
tblreason - reasons on why requests came back
tblreturn - where I have combined all 3 above tables to keep the information

I have made a query on tblreturn so when I enter them in the form it will sit there and not add to the above other 3 tables.



However here is the problem :

On the form I would like to be able to have a dropdown on the form so a dropdown box will let me pick the employee name and the rest of the employee details on the form being ext# and team leader and team number will auto fill..

Can someone please point me in the direction on how to do this I have been reading around but none of it makes sense probably like what I just asked about

thanks

[June7]

Here is one way:

Have the form's RecordSource be a query that joins the two tables. Set the jointype as "all records from tblreturn and only those from tblagents that are equal". Bind textboxes to the fields from tblagents, set properties Locked Yes and TabStop No so these cannot be edited from this form. This will display the related information on this form but will not save anywhere. It should not be as that would be duplicating data.

[Adsso]

Hi June7 - Thank you very much for the quick reply however I have made that query but I'm lost when it comes to setting the jointype ?

I have turned the textbox of Agent name into a dropdown so I would assume I set that up to read from the tblagents for the names ?

And this is where I'm confused.. Sorry I sound so stupid

[June7]

Set a jointype by double clicking the line that connects two tables in the query designer. That will open a dialog, click Jointype. If you have relationships established in the Relationship builder, the link and jointype set there will carry over to the query.

Yes, the combobox RowSource would be tblagents but its ControlSource would be the field in tblreturn.

[Adsso]

Hi June,

That part is now done - and now the relationships are joint type but I'm abit confused now on the binding so the agent name field works but what do you mean by bind ??

Sorry

[pbaldy]

Is this what you're after?

http://www.baldyweb.com/Autofill.htm

[June7]

Bind means set ControlSource to a field of the RecordSource.

pbaldy's suggestion for referencing columns of combobox is another method