Recent content by aecarpin

Hi, I am not to clear on the bound and unbound form, but the combo and the textbox field "TranfereeName" & "TranfereeAddress" are on a subform which is the Source Object of a form called frmCompaniesDetail (hope this make sense - see attachment). I've tried the code you've given but it still...

Thanks, but I still can't see where the problem is. The examples given on MS site shows the criteria (string) is hardcoded rather than supplied from a textbox object which confuse me.

I can find out what is wrong with my code. :confused: "TransfereeName" is a textbox where the string is either typed in or obtained from a combo. I want the "TransfereeAddress" to automatically filled in when the name is selected from the combo. The combo does contain the Address as well, but...

Very kind of you Paul, I will try that. Thank you. :D

I would appreciate a hand from some of you great wizard out there please. I am trying to assign the value of the primary key (autonumber)newly of a added record to a variable so I can use it to add a new record in another related table. I don't know what the syntax should look like. Please...

I have been struggling for days to achieve this simple procedure. I want to be able to print/preview a report based on the selection made from a multiselect List Box. I've tried using some of the code sample from this forum but can't quite manage to get it to work. The varItem seems to represent...