Access Help

[dsealer]

I want to up front apologize for my lack of knowledge with Access but still ask for your help
I have a very basic database. I'd like to create a form that will populate fields and record some data that is input.
First, I've created a Table that holds the data I want to use in the form.


This data consists of, "Description", "ID#", "Where Used", & "Cylce Period".
In the form I'd like to choose the "Description" from a drop down (combo?) box, and have the other 3 fields be populated with the associated data pertaining to the description.

I do have some experience with Access but haven 't used it in many years, so possibly once I get started again I'll remember some things.

Thank you for your help and I hope I've explained myself and question so you can understand what I'm trying to do.
Thanks,
Don...............

[pbaldy]

Does this work for you?

http://www.baldyweb.com/Autofill.htm

[dsealer]

Paul,
Thanks for your quick and helpful reply. I'm starting to understand, or at least I think so, but not completely.
I have a table with 6 fields in it. I have a form with 6 boxes in it, one being a combo box the other 5 being text boxes.
What I'd like to do with the form is make a selection from my combo box and have the other 5 text boxes be filled with the data from the table.
I can't seem to make that happen, can you direct me to the solution?
Thanks again,
Don..........

[pbaldy]

can you direct me to the solution?

I thought I did. What does "I can't seem to make that happen" mean exactly? Does the combo's row source include all the fields? Did you try one of the methods from the link?

[dsealer]

Here is what my "combo box" row source looks like.

SELECT [gagedescription], [gageid], [size], [whereused], [manufacturer], [calibrationfrequency] FROM [All Gages Table];
If that looks right then

I'm not sure about the textbox and control source "=ComboName.Colum(2)"
I don't understand how to write that into my database.

By "I can't seem to make it happen", I mean I can't get my database to perform the way I was hoping and the way you've instructed me.

Thanks again for you help and patience,
Don...........

[dsealer]

Paul,
Possibly I wasn't clear on what I would like to do.

My database has very little to it. I have a table with 6 fields;
GageDescription
GageID
Size
WhereUsed
Manufacturer
CalibrationFrequency

I have a form;
GageDescription = Combo Box
GageID, Size, WhereUsed, Manufacturer, & CalibrationFrequency. All of these are test boxes.

I'd like to open my form, choose a gage from "GagedDescription" and have the text boxes populate with the appropriate data.

Hopefully this will clarify my situation.
Don..........

[pbaldy]

Can you post the db? I believe the link is what you want, so perhaps I can demonstrate on your db.

[dsealer]

Paul,
My DB is 1.44 megs and I'm not able to upload it (can't be bigger than 500 kb)
Suggestions?

[pbaldy]

Have you done a compact/repair and then zipped?

[dsealer]

I think I've got it attached. I had a bunch of practice stuff in the DB that bloated it. I removed everything that isn't needed.
Thanks again for all your help,
Don ...........

[pbaldy]

This

=[Gage Description].Colums(3)

should be

=[Gage Description].Column(1)

Also, the column count property of the combo needs to be changed to 6. I also got rid of the after update code that was behind the combo.

[dsealer]

Thanks Paul, I didn't see the spelling error. I've pretty much changed everything to work properly. I do have a question. The code that is behind the after update, where do I go to get rid of that?
Thanks so much for you patience and help,
Don..........

[pbaldy]

I would simply delete it all. If you're not sure how to get to it:

http://www.baldyweb.com/FirstVBA.htm

and then delete everything from

Private Sub...

to

End Sub

[dsealer]

Okay so I'm starting to get there. I created a new table (Calibration DC) and changed the record source of my form to this table.
The purpose of the new table is to collect the data that is entered from my form.
It works almost like I want it to with one exception, it doesn't save all the data.

When I click on the combo box in my form called Gage Description it brings up all the data (Gage ID, Size, Where Used, Manufacturer, Calibration Frequency) and shows it. Then I enter the Date Calibrated, Next Due Date, Calibrated By, and Findings.

The data I enter is saved to the table but the data that populates the Gage ID, Size, Where Used, etc isn't saved.

Can you tell me what I must do to get that data saved in my table Calibration DC?

I've attached the db.
Thanks very much for all the help I've received,
Don..........

[pbaldy]

That was discussed at the bottom of that first link I posted. Basically you change the control source of your textboxes to the field name instead of the formula, and set their values in the after update event of the combo box.