How to get entry of a specific Edit-Box ?

[fluppe]

Hello,

here is another question from a (total) beginner:

I have a table and i use as the datasource for a Subform that is arranged as (1.) column of editboxes and (2.) a column of comboboxes.


Each pair of those corresponds to one record in my little table.
Now i want to automatically update something when the combobox is used, but i need the entry of the corresponding edit for that.
How can I get that entry ?

Is there a way to do that by addressing the editbox or should one better use the table itself ? But how can i use the table itself ? ... i do not have an index of the edited combobox or s.th..
I am using VBA to try that, but maybe one can define a link between the controls in the access-properties or something ?

Thanks for reading so far and a nice week everybody. I'd appreciate any help.

Greetings,
...

[June7]

By 'editbox' do you mean 'textbox'? What do you need the textbox value for?

What do you want to automatically update?

[fluppe]

i have a number and a name in that table which are corresponding "1-1". The combobox updates the "Name" and i want to update the number then to the corresponding value.
Therefore i have to find the record in the table which is identified by the name in the "Textbox".
That should work however, but seems to be a difficult thing i and i would really like to know what is the best way of doing this.

[June7]

Still not sure what you are wanting. Saving number and name sounds like duplication of data. The combobox should be bound to field where you need to save number value. The number and name should be columns of combobox. http://www.datapigtechnologies.com/f...combobox3.html

If you want to provide db for analysis, follow instructions at bottom of my post. Identify the form involved in issue.