Auto-fill

[sidewayzalex]

Hey again!

I have come to a dilema in some programming or preparation of my database. I am working on a Bill of Materials form which references a part Form/table. I was wondering if there was any way that I could simply enter the partID and the price and venderID would autofill as a default value, so that it is not mandatory for the user to override the value.

Please help.

I am posting some pics of the database for reference.

[pbaldy]

Is this what you're after?

BaldyWeb - Autofill

[sidewayzalex]

This is very similar to what I was looking at doing. The question is, is it possible to overwrite the information that is displayed? Lets say I save the data, which is necessary, because it is referenced in future calculations? And will this be displayed in the form as well?

[pbaldy]

Sure, if you use the second method:

Me.TextboxName = Me.ComboName.Column(2)

The code simply places a value in TextboxName. The user can change it.

[sidewayzalex]

Sure, if you use the second method:

Me.TextboxName = Me.ComboName.Column(2)

The code simply places a value in TextboxName. The user can change it.

Oh. I see... I enter that into the textbox in the form?

[pbaldy]

Enter what? If you mean the code, no, that would go in the after update event of the combo, as discussed in the link.

[sidewayzalex]

All right. I am sure that this is right under my nose, but I may not be following right.
What I have tried is making a new form based off of tblPartsPerOrder.
I have tried entering the following code, just to see if it works in both the [VenderID] textbox (which is the combo box), and the [Part ID] textbox. Keep in mind that I used the textboxes automatically created by FormWizard. The code is:
[Me].[Part ID]=[Me].[VenderID].[Column](2)
I have also tried:
[Part ID]=[VenderID].[Column](2)
and:
[tblPartsPerOrder].[Part ID]=[tblPartsPerOrder].[VenderID].[Column](2)

After trying each one of these in each textbox and testing if it works, I have come to the conclusion that I am either being very incompetant, or I am missing the smallest detail.

Edit: And I have entered all of this info in the After Event Update

[sidewayzalex]

If it helps any, here is the database I am working with.

Or not, wont let me post it... sorry for the irrelevant post.

[pbaldy]

The attachment didn't make it. Make sure you compact/repair and then zip, which should make it small enough.

[sidewayzalex]

I have it as a .rar now... and it is still 4000+Kb big.

[pbaldy]

Perhaps you can export this form and anything required to demonstrate the issue into a new db and post that? I don't have rar software, so zip works better for me.

[sidewayzalex]

I have tried that, and even then, it is remaining at 4000+
If you want, I can try taking screen shots and post them. Just tell me what you need screen shots of.

Thanks for your patience

[pbaldy]

Really? Does the form have embedded images or something? Did you do a compact & repair? It shouldn't be anywhere near that large. If it still doesn't work, I guess we can start with a picture of the after update event code. You did put that in the VBA window, not the properties window, right?

[sidewayzalex]

If you are available tomorrow, that would be best. As of right now, I am about to leave work, and will not have access to the database.

By the VBA window, you mean to enter it into the code section? or enter it in as an equation?

OH! And I tried deleting all of the embedded images of parts files (3D modeling) but it is still 4000+ even when compressed and zipped. I will take more screen shots tomorrow. I apologize for the inconvenience though.

[sidewayzalex]

Well... seeing as I am leaving work soon, I figured I could ask some more relevant and detailed questions.

Do I enter the code: [Me.Textboxname=Me.ComboName.Column(#)] into the textbox that will be relating to the combo-box, or do I enter it into the combo-box coding?

Secondly, do I enter the code as an equation, macro, or code. I have been assuming that macro was out of the picture, and most of what I have done has been as an equation.

Thanks for the patience