Recent content by Colleenm

Back in 1997, I created applications in Lotus Notes. I hadn't done any design work since then & now had the opportunity to recreate an application my office used for tracking debt collection from an internet app to Access. This was my first time using Access. Last Thursday, it went live & it is...

JHB, you have made my week, my weekend & my month... Thank you! I had tried using the table & then switched to a query out of trying so many things. I need to go read up on the Combo box. My understanding was that it passed it's selection to the "Collector" field. Obviously, my understanding...

JHB, I've uploaded my sample database.

Here is my sample database... The Debtorf form has the CollCommLookup field w/ the text label "Collector Comm" that is driving me crazy. It's where I'm trying to do the dlookup... My last try was using a query.

JHB, I'll create a copy of my db w/ sample date later today. Thank you for your time.

What changed? When I first created the combo box to select the Collector, it supplied the Collector field w/ a numeric value. My dblookup worked when creating a new record. Then I noticed when I opened up an existing record that had been imported from the old app, the Collector fields had text...

I watched 2 videos on joining table & am not understanding how that can apply to my form. My form current has information on a debtor. Then I have 3 subforms which track actions, addresses & payments. When the "Collector" field was a number, the dblookup worked. I'd create a new debtor, use...

Thank you for the prompt response. "Roger" is an example of the value in the Collector field in the Debtors table. I'll go lookup a youtube video on joining tables & try your solution.

After many hours of frustration & trying to copy examples from web searching, I'm breaking down & asking for help. :banghead: I am new to Access & have 2 weeks to recreate an application currently in an online internet app called Trackvia. Anyway, I know this is probably very simple. I have a...