populate txtbox based off another..cbobox & dlookup invo

[foxhound]

I have a text box (“txt_prespercent”) that is looking up a value in a table based off a value in my combo box (“cmbo_prespercent”). Anytime the value in “txt_prespercent” changes, I want to update another text box (“prespercent”) which has a control source from a field called “prespercent” in the underlying table that the form is based off. How can this be done?

Foxhound

 

[Corticus]

Re: populate txtbox based off another..cbobox & dlookup

Hi foxhound,

May be oversimplifying this but wouldn't this work:

private sub cmbo_presercent_afterupdate()

    'put this after you update txt_prespercent with looked up value
    prespercent.value = txt_prespercent.value

end sub

 

[foxhound]

Re: populate txtbox based off another..cbobox & dlookup

Corticus,

You did not oversimplify. I had one of those blurry eyed moments when things just didn't look right. Your code was perfect. Thank you

 

[Corticus]

Re: populate txtbox based off another..cbobox & dlookup

Wow,

Can't believe that worked, I wanted it to be harder. You should have seen the first answer I posted, I had DAO, and lookups and all kinds of stuff.

Glad it worked for you,