Recent content by luv2birdie

I need to create a return merchandise authorization form in our db to track returned products (under warranty). We will be using two tables. One to look up the original record of the product sold - serial and part number and update a RMA table with return details (RMA #, Date, reason and...

After looking over your dlookup function and the ones I previously tried I made a small change swapping the quote and apostrophe after [SN]= and added a set of quotes before the apostrophe at the end of the string, it worked. This is what I have... Me.txtPN = DLookUp("[PN]", "Products"...

I realize seeing the db would be much more insightful to help me but our db has quite a lot of information in it so I am not comfortable posting it in a public environment. I understand if this prohibits you from helping me any further. I do appreciate your help so far.

I changed it as you noted. I received a "Compile Error: Syntax Error" I attached a view of the code.

I opened the form in design mode, selected the "txtPN" textbox, opened properties, selected After update, clicked on the button with three dots, chose "code builder" then pasted the code in the middle of "Private Sub" and "End Sub". When I open the VBA application window and put my cursor within...

Gave that a try. It still doesn't work. It was highlighted red after pasting it. I don't know if that indicates a problem. This is how I entered it... Private Sub txtPN_AfterUpdate() Me.txtPN=DLookUp("[PN]","Products","[SN]="' & Me.txtSN & '") End Sub

I have a table with fields - two of them being SN - Serial number PN - Part number In a form I want to enter the SN in one textbox and have the the second textbox auto populate the PN from the same record. I am sorry if the first post was not clear - this is my first time posting to the forum...

Need Help! I have created a RMA (return merchandise authorization) form. I have several unbound textboxes. In the first textbox I want to enter in a serial number which is already in an existing table in my db. I want the second textbox to populate with its associated part number which is...

Hi, I am a current Access 2010 and looking to expand my knowledge of Access. I am hopeful this forum can help.