Recent content by MrBowder

thanks, but no luck... what does it mean that no errors pop up, no error code in the textbox, nothing since i cant get this dlookup to work, i tried even assigning one textbox value to another one and couldnt get that to work either. i am so lost on what i am missing here. i would love to...

I am sorry I am not explaining myself properly or I just have no clue what your talking about.. I have 2 tables, "Billing" and "BillingCodes" I have a query listing all the "Billing" fields and the "CurrPerUnit" field from the "BillingCodes" table... the "CurrPerUnit" field is often updated I...

Thanks for the reply.. it didnt do anything.. so I altered my form to try what your suggesting.. I made my BillingSubform record source a query and included the Billing table fields and the CurrPerUnit price from another table. So...when someone picks from the combobox (BillingCode) what...

I am sorry it took so long to respond.. tried it.. no luck.. no error, no ?name or anything if I cant get this simple thing to work.. ima gonna give up on access.. :confused:

I have figured that dlookup is the way I need to go... I have tried it dozens of ways, no luck, hopefully someone out there can tell me what I am missing. Btbl autoID...field1...field2...bcode...units...unitprice...field4 BCtbl bcodes...price...desc my subform (Charges) is linked to Btbl...

Suprisingly, I have yet to find a straight forward response. I have a subform (BillingSubform) that list what a person has bought. When a new record is being entered.. Simply, when someone picks from the combobox (BillingCode) what they want, I want the unit price field (PerUnit) to be...

duh.. new to Access I have looked for days and I am shocked I cant find the answer.. I have a main form I think called "Transaction Form" My subform is called "BillingSubform" subform is in datasheet view One of the columns is called "DiagCode1" Simple question is what do I do to copy the...