Recent content by lals101

Dear All, I'm kind of new to VBA in access and i'm trying to create a small dialog box that appears after entry of data in a form. Please bear with me. After a user enters an id number into a text box i wish a piece of code to run to check whether in the form's table the id number already...

Great thanks, but does it have to be an unbound text box?

ah i see what you mean, so the combo box would have all the information in it, and i could customise which items of data i see. I see the use of this, but it is not what i really need. Thank for your help anyhow

Yes it appears fine, ie it is in a logical order from top to bottom, when selecting fields.

Hi, I have a form with a series of tabs, in each tab lies a different subform. The problem I have is when the form is opened the focus is set half way down the main forms page, so that you see the entire subform, but you can't see the tab names. This is not good for data entry because the user...

How come "DLookup is hardly ever the right solution", Using combo boxes still means the user would have to enter name and address. This can be negated surely is after typing their ID number the name and address fields are automatically entered. The use of a combobox is likely to induce error, ie...

Hi, I have a register with a list of IDs names addresses etc stored in a table. In a form I have a text box where an individual enters the ID number, instead of filling out name and addresses again, could i simply populate/look up the names and addresses from the ID number and enter them in...

Great, pointed me in the right direction thanks!

Hi thanks for that, but I'm not quite sure where to start with the website I saw this code used in a similar post: Private Sub Command7_Click() DoCmd.GoToControl "Project ID" DoCmd.RunCommand acCmdCopy Docmd.OpenForm "The form name goes here" DoCmd.GoToControl "Project ID" DoCmd.RunCommand...

Hi all, I am sort of new to access and VB. I want to update/populate a text box (textbox_2) in one form (frm_enter_2) based on the entry of data in another text box (textbox_1) in form (frm_enter_1). Ideally I'd like this to be an afterupdate event, such that after the data is entered in...