Recent content by simonuk

Thanks that works great. I also need to lookup fields from a different table where I need to specific two different criteria. If tried using: strsql = "SELECT * FROM dbo_MemberAddress WHERE dbo_MemberAddress.MemberNo = " & Forms!Form1.memnum And dbo_MemberAddress.AddressType = "HOME"...

I would really like to do it through VB. I can almost get my code to work; the problem seems to be with the sql statement. In the code below it works and looks up member 3324. The problem is when I try and get the 'where' part of the statement to use the value in the form, it wont work I...

There are over 10,000 records in the central dbo_membermain table so having users pick from a drop down box would be a pain. I ideally want the user to enter a member number click a button and then have a number of different fields on the form populate from the main database. I can do this...

Hi thanks for your reply. The recordsource of the form is already set to a table called member_requests. The purpose of the form is to create a new record in this table to store members requests. I want to lookup some of the fields from dbo_membermain this being a seperate SQL database...

Hi everybody I'm a total access/vba novice and looking for some advice on how to populate a number of text box controls on an access form with data from a table. There will be around 15 fields that I need to be auto populated once the user has entered a member number. I can get this to...