Recent content by ramondrumon

COOOOOOOOOL. I've been try to get this solved for weeks and you have me on the right track now. Thanks!!!!

Okay, I'm getting closer, my only problem now is that one contractor may have up to 50 employees to choose from. I think this is where it gets ugly!

You understand my question fine, but if I have Prime contractors in one column and Sub contractors in a second column and choose one column, I would be choosing a Prime and a Sub both, they both need to be in one column.

I'm having a hard time getting an answer to this because I don't really know how to explain. I need a combo box that will have two tables with one field from each in the same column ( i can do a union query ok), the fields are (subContractors & primeContractors). I need this combo synchronized...

I want to synchronize three combo boxes and the information needs to come from two different tables. I made a union sql from the tables and this is where I am stranded, anyone have any ideas? The two tables need to be separated other than for this purpose, I have access 2000.

I don't have a problem synchronizing combo boxes, if I choose multiple items in the list box (each is it's own record) I want the form to update all of the records with the same info from the form. I hope I am making some sense now.

Combo box titles: 1001 Demolition 1001 1.1 Concrete demolition 1001 1.2 Wood Demolition I have a combo box which will show [1001 Demolition only], if I Pick 1001 demolition it will update a list boxt to this: 1.1 Concrete demolition 1.2 Wood Demolition This in turn is...

I did not make myself clear, the text box automatically starts a new line, but I don't want the next string to be on two lines if it is to long, if the 1st line is about full, I want the next string I insert to stay together and go to the next line.

I have a text box that can take 3 lines of information, I have a list box that when I click on a row the info is inserted into the text box, then I click on another in the list box and it is inserted too. My problem is that when I insert some info to the text box, the info can be broken in half...

Forgot, FrmSubmittalLog is the subform name.

I have this code in the current event of the main form to set focus to a text box of a subform. Forms("FrmSubmittalLog").SetFocus Forms("FrmSubmittalLog").SubmittalIDNo.SetFocus I get an error saying it can not find the FrmSubmittalLog, and I can't figure it out, so some...

I can do it this way if I have to, the drawback to this is when I will fill out the new record I actually use information from 3 or 4 records that are in order, forgot to tell you that.

I put a button on the form and then created a macro and then use the macro in the click event of the button. There are some sample macros in Northwind to study, they are not to difficult to do and once you know how to use them, they are a pretty handy tool.

I don't think I understand what you are saying, you may have to spell it out for me, but if I add the new record at the end, I will not have the record I want to use as a reference which may be a couple hundred records back.

I have a continuous form (form view) and new records are inserted after the last record. I would like a blank record line inserted between two records, then I would be close so I could copy some of the related information to fill out the new record and (2) it would then be next to the record I...