Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DLookUp function only works when form is opened?
- Thread starter wshs
- Start date
Depends on where you are using it. If you are using it in a query, then it runs when the query is opened.
Leslie
Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual
Essential reading for anyone working with databases: The Fundamentals of Relational Database Design
Leslie
Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual
Essential reading for anyone working with databases: The Fundamentals of Relational Database Design
- Thread starter
- #3
so is there no way to call a value from a table that is closed? by that i mean..
lets say i have 3 dynamic forms.
a opens b and then b opens c. and c prints
when going from form A to B some info are transferred and recorded to a table.
when going from B to C.. same thing.
is there no way then to recall something from TableA to C?
man.. this is hard to explain.. making any sense?
lets say i have 3 dynamic forms.
a opens b and then b opens c. and c prints
when going from form A to B some info are transferred and recorded to a table.
when going from B to C.. same thing.
is there no way then to recall something from TableA to C?
man.. this is hard to explain.. making any sense?
wshs,
Are you saying that upon the mere act of opening form B, for instance, you are writing a value to table A? Then you want to read that value in Form C?
I'm having a hard time understanding, but since you mentioned the dlookup, if this function is in a textbox, you could requery the textbox to get the latest value.
For instance, upon the event that causes a write to table A, then requery the textbox that's looking for that value right after the write.
--Jim
Are you saying that upon the mere act of opening form B, for instance, you are writing a value to table A? Then you want to read that value in Form C?
I'm having a hard time understanding, but since you mentioned the dlookup, if this function is in a textbox, you could requery the textbox to get the latest value.
For instance, upon the event that causes a write to table A, then requery the textbox that's looking for that value right after the write.
--Jim
TheAceMan1
Programmer
How are ya wshs . . .
[blue]An example is in order here! . . .[/blue]
See Ya! . . . . . .
[blue]An example is in order here! . . .[/blue]
- Thread starter
- #7
i have a table "VRegister" which consist of budgetlines. (fund, revnumber, amount, etc.) bfsix = unique
user will be using form "SelectBudget" to store all the transactions and all those will be captured to VRegister.
Now when user wants to print a check from form "Checking",
i was hoping i can use 'bfsix' to find the correct fund, revnumber, etc from "VRegister and pretty much transfer all the same info. am i making sense?
user will be using form "SelectBudget" to store all the transactions and all those will be captured to VRegister.
Now when user wants to print a check from form "Checking",
i was hoping i can use 'bfsix' to find the correct fund, revnumber, etc from "VRegister and pretty much transfer all the same info. am i making sense?
- Status
Similar threads
- Locked
- Question
