Search results

Try this: If txtConsole = "PS3" or txtConsole = "XBOX" or txtConsole = "WII" Then NEWGEN_FL.Value = -1 End If

Can you post the sql for the query so we can check it out?

Your Welcome, and I am glad you figured it out on your own! Good luck. :)

Set the add property to "no" on the form properties.

You are both very welcome, I am glad you got everything working. :)

Oh, I also think the "[Event Procedure]" on the click events need to be redone to connect the controls with their code. It got broken when I moved everything.

OK, Cut the controls as a group off of your form. Select the tab control, and make sure an orange box (border) comes up. Click on it to make sure your there then paste the controls you cut back on. This should paste them into the tab which is on the form instead of pasting it on the form.

That means that you didn't get the controls into the tab, but only on the form. I'll have to play around with it to see if I can get it.

Try this I moved the line "SetVisibility False" From the Form Open Event to the Form Load event after the go to new record command. I have attached the changed version EDIT: I am not sure why, maybe it has something to do with the fact that on the open event the "cmdShowLists" button is...

That's what I meant, sorry. If you can, upload your db, the one you copied everything into to here.

Is the name of your combo box once copied over still cmdShowLists?

Well, what do you know, now when I removed the ".Column(2)" it worked. :)

I have always had problems with list boxes if I didn't declare the column, even in A2003. I think it was a thread I had on here that someone told me about that.

Sure I can, I'll do it right now, but it was my understanding that you always had to use ".Column(x)" In these cases. So I tested it and the message box comes out the same.

How about years like this: Between 17.75 and 18

Hey, I show that the bound column is column 3 (And it is the ID) - See Screenshot EDIT: Also, Your welcome for the testing

OK, Given the form in the DB in Post 37 that you asked me to look at I found the following: You needed to add the ".Column(2)" so that it knew to look at the bound column of the listbox. Private Sub lstDayShift_Click() Me.lstNightShift = Null Me!TimeID = Me.lstDayShift.Column(2)...

Hey, I'm sorry, work has been a little crazy, I haven't yet, I will try to today. In the meantime, if someone else can help please do!

Just for closure on this, babinos PMd me, here is what he said: Which I think is exactly what I was showing him with the attachment I had.

Here's a A2003 version