Ms access form query

baroom · Jun 7, 2009

HELLO
i have a form with two fields.
lets say item no and item name
it i enter item no then depending on this item no item name should be displayed from the table in the form.

i think this is very simple to u all .
please help me how to display the contents in the form from the table.

thankyou

missinglinq · Jun 7, 2009

Something like this, depending on whether Item No is numeric or text

'Item No is Text

Code:

Private Sub Item_No_AfterUpdate()
  Me.Item_Name = DLookup("[Item Name]", "YourTableName", "[Item No] = '" & Me.Item_No & "'")
End Sub

'Item No is Numeric

Code:

Private Sub Item_No_AfterUpdate()
 Me.Item_Name = DLookup("[Item Name]", "YourTableName", "[Item No] = " & Me.Item_No)
End Sub

Notice that if your actual names are Item No and Item Name, with spaces, Access will include an underscore in the code module. Having names with spaces is really a bad idea.

baroom · Jun 8, 2009

Thanks for your reply i did exactly as u said

Private Sub Item_No_AfterUpdate()
Me.Item_Name = DLookup("[Item Name]", "YourTableName", "[Item No] = '" & Me.Item_No & "'")
End Sub
but at the time of runniong the form it is giving me run time error what is the problem please tell me
how to sort out this situation.

missinglinq · Jun 8, 2009

Did you replace YourTableName with your actual table name?

seasif · Jun 10, 2009

HI,

I want to have the same functionality on the query also, I mean once i saved and then when i will open that record again so name should be populated as well?

Please tell me on which event will i have to write the same code?

Thanks & Regards
Asif

Ms access form query

baroom

Registered User.

missinglinq

AWF VIP

baroom

Registered User.

missinglinq

AWF VIP

seasif

New member

Similar threads

Users who are viewing this thread