Trouble getting data to "register"

[KelMcc]

In the form I'm working on, I have 2 combo boxes (they could be list boxes too, I don't believe this part matters).

The first is a list of project descriptions, "projects". You select a "project" and it requeries the 2nd box to pick the appropriate project number, "projectSR", for the "project" you have picked.

Ok, we're dandy so far.

The problem is, I want the "projectSR" box to populate the underlying table without having to click on the box itself. Yet, the form will not "register" (sorry don't know the proper access term for this function) the data in the table unless I click on the "projectSR" box. This is very annoying.... grr!!!

I'm sure there's some simple, bonehead thing I'm missing. Please demonstrate my folly to me.

Thanks in advance!

 

[DBL]

Is the ProjectSR the id number (autonumber) for the project?

If it is, if you add the project SR column to the query for the project combo box (put it first in the query grid), change the number of columns in the Project combo properties to 2 set the column widths to 0;2 (or whatever for the project description) and make column 1 the bound field and make it the control source for the Project field on the form then it should save the ProjectSR number to base table.

Sorry if I'm on the wrong track

 

[KelMcc]

It is a number, but its not an autonumber.

 

[DBL]

Is it the number that linkes the two tables together? If it is, then the above would work too.

 

[KelMcc]

Well, both fields are from the same table. They do have a 1-to-1 relationship, if that's what you mean.

I will try and do as you suggest later today/tomorrow and see what it yields. In the mean time if anyone else has any thoughts/suggestions, I'm game.

Thanks DBL!

 

[KelMcc]

DBL,

What you suggested wasn't working for how I was envisioning things, but it gave me pause to reconsider how I was gonna do things, so, now it is working and I did use your ideas and I'm happier w/ it.

So, tx very much!

 

[DBL]

Excellent! Glad you got it to work.

 

[RichMorrison]

you wrote
<<
The problem is, I want the "projectSR" box to populate the underlying table without having to click on the box itself. Yet, the form will not "register" (sorry don't know the proper access term for this function) the data in the table unless I click on the "projectSR" box. This is very annoying.... grr!!!
>>

Sounds like ...
Access does not know how to "populate the underlying table" because you have not selected anything from "projectSR".

RichM