Solved DlookUp not working

[Manos39]

Hello
i would like your help..
need texbox to show value [tmimaID] on my form Fr_Athlets, based on
value on table "Tbl_StelehosiTmimaton" and it seems i cant even though i ve tried...

 

[CJ_London]

see this link for how to use dlookup

DLookup Function - Microsoft Support

Use the DLookup function in Access desktop databases to get the value of a particular field from a specified set of records.

support.microsoft.com

there are three parameters passed as strings. you have two and not as strings

 

[Manos39]

I cant think better please help

 

[Manos39]

tried this solution, dont work either

=DLookUp([tmimaID]![Tbl_StelehosiTmimaton],[athletID]![Tbl_StelehosiTmimaton]=" & [tmimaID] & " And [AthletID]=[Forms]![Fr_Athlets]![atheltID])

 

[arnelgp]

=Dlookup("tmimiID", "Tbl_StelehosiTmimato", "athlethID = '" & [atheltID] & "'")

 

[Manos39]

Thank you but it gives me error

=DLookUp("tmimaID","Tbl_StelehosiTmimaton","atheltID = '" & [atheltID] & "'")

 

[KitaYama]

It can help if you explain what error you're receiving.
atheltID is a number then :

=DLookUp("tmimaID","Tbl_StelehosiTmimaton","atheltID=" & [atheltID])

 

[arnelgp]

what is the Lookup Table of tmimalID fieldf?

 

[Manos39]

It can help if you explain what error you're receiving.
atheltID is a number then :

=DLookUp("tmimaID","Tbl_StelehosiTmimaton","atheltID=" & [atheltID])

that helped but it returns numbers like 2, 4 , 5 etc

 

[arnelgp]

On Design View of table Tbl_StelehosiTmimaton, click on Lookup Tab (below panel).
post the SQL of the Rowsource.

 

[Manos39]

On Design View of table Tbl_StelehosiTmimaton, click on Lookup Tab (below panel).
post the SQL of the Rowsource.

ok, for tmimaID

SELECT [Tbl_Tmimata].[tmimaID], [Tbl_Tmimata].[ONOMA] FROM Tbl_Tmimata ORDER BY [tmimaID];

and for athetID

SELECT [Tbl_Athlets].[atheltID], [Tbl_Athlets].[ΕΠΙΘΕΤΟ], [Tbl_Athlets].[ΟΝΟΜΑ] FROM Tbl_Athlets ORDER BY [atheltID];

 

[arnelgp]

=Dlookup("Onoma", "tbl_Tmimata", "tmimaID = " & Nz(DLookUp("tmimaID","Tbl_StelehosiTmimaton","atheltID=" & [atheltID]), 0))

 

[Manos39]

=Dlookup("Onoma", "tbl_Tmimata", "tmimaID = " & Nz(DLookUp("tmimaID","Tbl_StelehosiTmimaton","atheltID=" & [atheltID]), 0))

WOWWW

Thank you very much

 

[Manos39]

=Dlookup("Onoma", "tbl_Tmimata", "tmimaID = " & Nz(DLookUp("tmimaID","Tbl_StelehosiTmimaton","atheltID=" & [atheltID]), 0))

Thank you very much

 

[arnelgp]

Thank you very much

you're welcome!

 

[Manos39]

is there an easy way for disolve problem giving error on when entering data on a new record?

 

[arnelgp]

with the New Expression, test your form. i think there will be no more error.

 

[Manos39]

with the New Expression, test your form. i think there will be no more error.

I ve tested it is superb but when theres no record on form i am asking

 

[arnelgp]

what is the RowSource (the SQL string) of the combobox?

 

[Manos39]

what is the RowSource (the SQL string) of the combobox?

i hope you mean this


i ll try answer later .. have to go thank you