Search results

Since there was no solution to this I found a work around. All I did was use the separate text box that shows the Project Name and put it on top of the combo box, leaving only enough space to show the arrow to activate the drop down box. I know it's a long winded way of doing things but its...

Right I am halfway there...so far it works again, because I deleted the following code Private Sub Form_Current() Me.cboProjectName = [ProjectName] End Sub I also changed the bound column back to 1 as having it at 0 was coming up with "Record not found: Filtered?", which is a error handling...

Please note the Combo Box is used to navigate between records, and not change a value, thats why the control source is blank.

It doesn't have a control source as it is unbound. Also I am certain the combo box is bound to the second column, as ultimately all Im interested in is displaying the Project Name in the combo box. But I'll give you the benefit of the doubt and try it... ...It didn't make a difference it did...

I tried debugging and at the same time created a cmd button that did basically the same thing. Private Sub Command143_Click() Me.cboProjectName = Me.txtProjectName End Sub So I then I set a break point at the end sub and debugged it. print me.cboProjectName London School This shows that the...

The problem if I did that would be that cboProjectName would become the project number say 50 for example which means nothing to anyone, rather than the actual project name say xyz ltd. And under properties it says bound to column 1, which is actually the second column. Please note that the...

Well the code was no different even when I deleted the line - Me.cboProjectName.Value = [ProjectName] So that has confused me more. Just to help your understanding a bit, I have a combo box which is used to select which record to go to on the form. This combo box has a row source of both...

In fact, I can remove the other part as it is not really doing anything at the moment. The only part which is not working is: Me.cboProjectName = [ProjectName] There is a seperate hidden textbox which shows the ProjectName of the Current record, and the idea is that that name should appear in...

bump.........

There rarely is an open argument, so that shouldn't really affect it, most of the time it would just go to the first record. I am aware that really speaking 'Me.cboProjectName = [ProjectName]' should be in the if test under else. So I did what you suggested and changed the bottom line so it...

I decided to split up my database by putting the back end onto a server PC, and distribute the accde version of my database. However straight away I noticed that there has been a problem with it sort of ignoring part of the code on one of my forms. Here is the code: Private Sub Form_Load()...

I've got a form which is used as a pop up for selecting a customer and a project, we will call this form frmCustomer for arguments sake. The first form will be used to select data for the quote, and in order to associate a customer and project, the user has to click a button which will open up...