Need Dlookup from one lookup value get result through 3 tables to different textbox

[johnexcel]

Dear Experts

I have set of data table Dispatchcalls Total Column Field 43,Closedcalls Total Column Field 49 ,CancelCalls Total Column Field 40 and I have forms called "SearchSerialNo Status " In the form i designed data wizard forms with multiple textbox and cmd button.

I want dlookup from "Entered Serial No" where Input Value entered and click "FIND SO's" cmd button get result from Dispatch,closed,cancel tables

E.g In the Form First 12 FIELD textboxes Dlookup FROM Table-Dispatchcalls through lookup values of Entered serial No.


In the Form First 11 FIELD textboxes Dlookup FROM Table-Closedcalls through lookup values of Entered serial No.
In the Form First 2 FIELD textboxes Dlookup FROM Table-Cancellcalls through lookup values of Entered serial No.

Find the Zipattachment

1OnsiteDCC -Msaccess
2Example.xlsb file is attach of example for understanding my requirement



thanks in advance

[ranman256]

No need for Dlookup. (or code)
If you fill out the text box, then it would open a query that uses the textbox in the where statement.
like Query1: select * from tCancellCalls where [serial]='" & forms!frmFind!txtSeral & "'"

If you want to show data in a form..
just filter the existing form based on the data in the box

me.filter = "[serial]='" & txtSeral & "'"
me.filteron = true

[johnexcel]

Dear sir

Can u upload output file with chances of my requirement? i little dump of msaccess i just start learning

[rpeare]

I don't think ranman looked at your database, it is an unbound form, and as far as I can tell you have no code attached to any of it yet so filtering would produce no result.

Your form also assumes there is only going to be ONE instance of the the serial number in each of your three tables. If that is accurate we can proceed, if it is NOT accurate, in other words a particular serial number can appear multiple times in each table, how are you determining which record you want to look up?

[johnexcel]

Dear sir

The Lookup value is not Serial No I need lookup through order no ,In every table In 3 column field i make changes of one caption of form
find the attachment need ur help

[rpeare]

Why are you attempting to do this with an unbound form?
Why not create a bound form where the user can put in an order number or partial number order then bring up all data related to that order number from each table (the pieces of data you want)?

For someone who is struggling with dlookup it would be far easier than trying to do this on an unbound form.

[johnexcel]

How to do this bound form...can u make me to do this?