Recent content by Laura

Having problems trying to get rid of the blank records which automatically appear in my subforms. I have 2 subforms embedded within my main form, and usually either one or the other contains information and in certain cases both do. however there is only ever one instance of each information...

I have decided to use tab controls, as my forms were getting complicated. However I am not use to using them and am having a couple of problems. On page1 I have a search page which uses a query to list all the customers within a list box. From here, previously, I have use a command button to...

How can I display a MsgBox showing a warning if the user violates a multiple index and enters repeating data?

How can I display a MsgBox which tells the user they have broken a multiple index rule and entered repeated data?

Wonder if you can help me regrding the relationships in my Database which I think are affecting my forms. I have a table with a primary key called customerID and 2 foreign keys called acting and not acting. Therefore, as the information is stored, a customer has either an acting or not acting...

thanks I appreciate that. Also one last question, what is the syntax for stating lots of criteria? I have tried "whatever" or "whatever", like in a query but it doesn't work. I have also tried commas and brackets and cannot find the syntax in my book or on help.

This is great apart from I led you astray saying the condition is in a text box. in fact if I want to do this properly I will have to relate this code to a list box. So the list box called DeceasedList I have already mentioned has 5 columns and the 5th column is what i want to use for the...

I am having problems with the code below because I would like to add a condition which states If txtbox = "certain data entry" then open form1 else open form 2 but I can not seem to get my syntax right, here is my code: Private Sub open_estate_Click() On Error GoTo Err_open_estate_Click...