Recent content by Tieval

As simple as that :sneaky: Many thanks for your help Minty.

I have a query that has values for different fields such as: 1 Type A 2 Type B 3 Type C (and many more) This query is used to generate a continuous sub-form from data such as: Record Description Value 008 An Item Type A 009 Another Item Type B A combo box...

Many thanks Vlad, it seems just right but I will investigate fully and get my head around what you have done :)

Oh, and Pat, you are correct the colours are terrible. I tend to deal with the operational side of things and it should therefore all be default grey black and white but I have the tendency to play with looks while I am thinking about more important things and my development work always looks a...

Hi All, Many thanks for the interesting input and the effort put into replying. Firstly I am no novice, just haven't touched it in a couple of years. I have a full understanding of bitwise as I use it for electronic equipment programming in C++, until I fully understood the idea of the...

It was to enable a lot of items to be seen in the list and more detailed data to be shown separately which is what I am trying to achieve. I want to be able to look down the list, select one and see the details.

I am getting sPath Value out of Context

I have attached the database and the issue is in frmPartsList loading the subform frmPartsListPic

Private Sub Form_Current() Me.Image202.Picture = CurrentProject.Path & "\Pictures\" & Nz(Me.Text6, "NoPhoto.jpg") End Sub I do actually have an error on form loading now of You entered an expression that has no value.

Yes, no error at all, just doesn't work.

Unfortunately Not

I am now being really stupid, how do I get the value from a text box into this code? The below does not work.

Pat, I am not the expert here but the method adds one column storing a data value between 2 and 254 and then works out what this applies to. It does work as per the attached. You may want to take it up with Arnelgp why there are technical issues but I do not see any problems. I don't ever want...

That also works a treat, many thanks again.

That seems to work a treat, many thanks.