A ashok New member Local time Today, 18:19 Joined Sep 11, 2008 Messages 6 Sep 12, 2008 #1 Hi, I would like to assign a value to a textbox(txtExpID). The value is coming from a query qrymaxvalue. I would like to see the max value in that textbox. Could some help me out to fix this. Thanks, Ashok
Hi, I would like to assign a value to a textbox(txtExpID). The value is coming from a query qrymaxvalue. I would like to see the max value in that textbox. Could some help me out to fix this. Thanks, Ashok
missinglinq AWF VIP Local time Today, 18:19 Joined Jun 20, 2003 Messages 6,420 Sep 12, 2008 #2 I don't believe you can use a query result as the data source for a textbox. You can, however, use a function such as Me.txtExpID = DMax("YourFieldName" , "YourTableName")
I don't believe you can use a query result as the data source for a textbox. You can, however, use a function such as Me.txtExpID = DMax("YourFieldName" , "YourTableName")
A ashok New member Local time Today, 18:19 Joined Sep 11, 2008 Messages 6 Sep 14, 2008 #3 Thank You. Its working.Its really great help.
missinglinq AWF VIP Local time Today, 18:19 Joined Jun 20, 2003 Messages 6,420 Sep 14, 2008 #4 Glad you got it working! Linq