Recent content by jlc28

Thanks to both of you, Tickles and Tree_Buddy. I've got it working now. :)

I have built a form and a report. However, what I want is to print the report with only the one record that's showing in the form. For example, workorder number 300045 is displayed on my form, I want to be able to print this but in report form. However, everytime I try to do this, all the...

Never mind. I got it. Stupid mistake. Thanks

I just went through the same thing, Take a look at my posting for connecting two columns. That's exactly what I just did. It worked too. :o

I have been using the code "PWW" & Format([PWWorkorder],"0000000") in order to automate a workorder number. However, because this field is primary key it keeps giving me the error Index or primary key cannot be null. It's not throwing the number back into the table. How can I fix this...

Bradcccs = I did have the right name but for some reason it wasn't working. However, I left it for a few days and redid it today and now it works. Maybe I had some properties messed up. Who knows. Smercer = I actually wanted the person to select based on the name and then in another box...

Uh? =cboComboName.Column(0), I placed this in the controlsource of the textbox and I get that error "#Name?". Any suggestions? :eek:

I'm sure this is easy. I'm just slow. ha ha. Anyway, I have a combo box that lists vendor names. Now I want the vendor ID number to be automatically shown in either a text box or list box, whatever. I just want the ID number to show, that corresponds to the vendor name. Help! The ID and...

I would I would but there are over 4000 records. It's a list of vendors and so the information needs to be accessible from the form.

Hi! I have a form, let's say it's called form1. In one of the fields I have the OnClick set to open another form, form2. This form2 is acting as a list of values for the user to select from. My question is how do I get the information from form2 to be placed in the field of form1 based on...

Thanks so much. That worked great. I appreciate the help. :p

I would like to automate the number in my form. I have the field within the table set to autonumber. However, I would like to place three characters in front of the automated number. For example, PWW000001, PWW000002, PWW000003, PWW000004 etc etc. Can anyone help me? It's probably easy but...