Recent content by andy_25

That is exactly what I was looking for. I worked it out before reading your response, but thanks :)

I have added the column widths so the user can view the columns. Where do I specify that there are n columns so the ComboBox displays the columns selected? I cannot get it to show anything other than the bound column once selected. Any chance you can knock up a quick example?

Thanks guys those responses were very helpful. I was hoping it was going to be easier than that. I have used a combination of the 2 to come up with a solution. I passed the data to textboxes (hiden) as with the example given, then passed them up into a single textbox. A bit of a mess I know...

Solved: ComboBox to display all fields not only the link Hi all, I have got a ComboBox which helps the user select a person they are looking for. When it is clicked it shows their FirstName, LastName and JobRole. However once they have made the selection it only shows the first value i.e...

I've tried this in a new test database and the same thing happens. I would be grateful if you could have a look :)

In the Applications table there are several entries of Contract_No with the value of 2 and one in the contracts table.

Yes it keeps inserting 1 into Application_No. I added a messagebox and it confirms the variable is sticking at 1

for testing purposes on form load I set txtContractNo to the value 2 so it should increment each time but it isn't

No error now but it is giving out 0 as the Application_No everytime. When I add +1 to the end of the code it is giving out all 1s i.e. not seeign that 1 is already there. I'm confused

Number - Long Integer

Yes. I can't get Galaxiom's code to work either even with referencing the form i.e. curAppNo = Nz(DMax("Application_No", "APPLICATIONS", "Contract_No =" & Forms!frmAddApplication.[txtContractNo]), 0) + 1

Error Missing operator in Contract_No =

Yes I agree, it was Long but I put it as Byte when I was messing around with it. I get an error Thanks for the input; once I got the code working I was going to think about the best place to put it, now I know :)

Compile error, Expected: list seperator or ) Apologies, I can;t figure out what's missing

Hi all, I'm sure one of you guys can spot the problem here? I have been banging my head against a brick wall for 2 hours :( I am trying to find the highest Application_No and add 1 to it and then pass it to a text box. Easy right??? Private Sub Form_BeforeInsert(Cancel As Integer) 'curAppNo -...