Access Form/Table help

[gophertee]

This is what I have:
tblDeveloper (fields: Programmer and Cost)=these have data.

tblDeveloperX (fields: Programmer and Cost)=reads what I select from the form.

I have a form which reads data from tblDeveloper. Hence a drop down box:

Developer Cost
Al $25.34
Ben $35.00
Tim $45.55

Basically when you select one of these fields from the form combobox, it takes it to the tblDeveloperX, which is ok.

What I have is:
control source=developer
row source type=table/query
row source=tblDeveloper

How do I get both Developer and Price to tblDeveloperX????

 

[Dreamboat]

I'm sorry, gopher, if I'm being brain-dead, but what you're doing doesn't make any sense to me.

Sounds to me like you're using tblDeveloper and tblDeveloperX should not even exist. Two tables with the same data is not a normalized database.

If you can tell us why you're choosing to get the programmer into the tblDeveloperX, then maybe we can help you move forward.

http://www.PiersonTech.com

dreamboat@nni.com
Brainbench MVP for Microsoft Word

 

[gophertee]

Basically tblDeveloper has all my stored data. Hence I have about 20 records in tblDeveloper. Using that table I can create a form and see everything in my drop down combo. As if your in the form, looking at the combobox and selecting a developer which along side of the developer is cost (exactly like the tblDeveloper has it).

The thing is when I select a developer in the form (clk with the mouse) it takes what I selected and puts the data in tblDeveloperX. TblDeveloperX is in my form control source. Keep in mind the combobox has two columns (Developer and Cost) because that is what is in the tblDeveloper. I can't put anything in tblDeveloper because that is my source file which is building my form combobox. I have tblDeveloperX so when I select from my combo I can select a record and it adds to tblDeveloperX. But, all it adds is just developer. Not Developer and Cost.

 

[gophertee]

Basically to make it easier for everyone. In my form I have Developer and Cost (i.e. Tim $45.35). I can add Tim,$45.35; to my rowsource which is a combobox with 2 columns.

All I want is to copy what I selected from the form to a table. I don't care if its a combo or list box in the form. Only thing that copies is Tim...I want both Tim and the $45.35 in my table...

Is it Friday yet? UGGGGGH

 

[Dreamboat]

Don't do this in the form, gopher. Instead, open tblDeveloperX in design view. If you have the cost in this table, just remove that field. In the Developer field, choose the format to be Lookup (instead of text or whatever). Let the lookup wizard help you through looking up the developer name from tblDeveloper (and including the cost field). When you create a form based on that table/field, it'll automatically give the dropdown lookup. Hope it makes sense.

http://www.PiersonTech.com

dreamboat@nni.com
Brainbench MVP for Microsoft Word