Use form fields to run Query

Where and how exactly is the data stored, can you please provide the table structure, eg;

tblParts

PartId - AutoNumber, Pk
PartNumber
PartDescription
PartImage

Thanks

Hello,

Just an approach you might want to try...

1. Set up a combo box control on the form
2. Create a query for the data you want
3. Make the Row Source Type = Table/Query
4. Make the Row Source the name of the query
5. limit to list = yes
6. set the column count of how may columns are
   returned from the query
7. Use the column widths to adjust what is shown in
   the combo box for the user and set List Width
   Column Widths setting example for showing 3
   columns = 0.75";2";0"
8. Tweak these combo box properties to get them
   the way you want them
9. In the combo box pick an appropriate event,
   like "On change"
   
   In the event routine add code that will
   populate the fields from the query rows example:

    'Based on selection populate the fields
    Me.txtVendorNumber = Me.cboVendor.Column(0)
    Me.txtVendorName = Me.cboVendor.Column(1)
    Me.txtAddress1 = Me.cboVendor.Column(2)
    Me.txtAddress2 = Me.cboVendor.Column(3)
    Me.txtCity = Me.cboVendor.Column(4)
 
    This will fill the fields on the form based
    on the selection made in the combo box

Hope this helps you get what you need.
B

I have a table set-up with many pieces of information, way more than I need to use. The query will look up Part Numbers and Pictures from the table with the criteria that the company name is our company. I've got that part working fine. However, the images that I have in the table are linked .DIB files, not embedded images. I think that this might be the problem. When I try to use bobHacker's solution, it gives me an error that the object doesn't support this property or method (Error 438). I tried using a bound and an unbound object frame, and they each returned errors when trying to apply the OLE Object from the table. Any tips about applying that image to the field, or will I have to embed the images into the database?

Hello mac

I have not worked with images but I would not store them in the database
for size conciderations.

I would store them in a folder and in a database table
you could use a key field # in a table that points to where
your pic is and load it on the form based on the key

imageID imagePath     imageName
1       "H:\images\"  partxxx.jpg
 
in the form
add a query / QDF (based on the selection from the combo box)
get imageID, imagePath, and ImageName

load the image object

Image1.Pic = strImagePath & strImageName)
 
(Image1.Pic = "H:\images\" & imageName)

Have not seen your err 438  

Hope this helps you get things going.

B

I uploaded an image of how my form looks currently. This is how I would like the final to look.
Sample-Layout.jpg

Hi

Perhaps another expert could help you further?

thank you
B

OK, I've made a bit of progress with this now. My form is still laid out as in my previous post. I have 32 text boxes (Text1 - Text32) and each text box has a Picture (Sample1 - Sample32) above it. I have a small bit a VBA written:

Private Sub Text1_AfterUpdate()
 Dim PicPath As String
 PicPath = "C:\XXX\Images\"
 Me.Sample1.Picture = PicPath & Me.Text1 & ".dib"
End Sub

Select allOpen in new window

So after I update the text box, the picture above changes to become whatever image corresponds to that part number. However, my form currently has no record source and it loses the entries when reopened. I was wondering if someone could help me write some code that would keep the entries upon reopening the form.

Someone else may have a better way to go about this, however, here is my suggestion;

Have a table to store the latest user defined layout.  Store the image layout location (Which control it appears in on your form) and the file path for the image.

You could then have your form update the data in your table using the on change event from a combo box that allows the user to select the part that they wish to display the image of, or, you could have a button that stores all locations once they have decided on the layout eg, a "Save New Layout" button.

I would definately use a combo box to select the part.

DockieBoy, do you know of the best method to go about your plan? I've been using Access for a while, but have only learned that parts that I needed in order to get to where the database is. Therefore, there are many aspects that I do not know. If you could just let me know how to store the layout information into a table, the help would be greatly appreciated. Thanks in advance.

Solution I came up with.