Auto Fill

[resolva]

Hey all,

I am testing out an auto fill for a project.

I basically want to choose from the information in the combo box and then display the price in the other text box there.

I have attached the database file, would be great if you could have a look what is wrong with it.

Regards

Aaron

 

[ajetrumpet]

SEARCH SEARCH SEARCH!

http://www.access-programmers.co.uk/forums/showthread.php?t=155420

 

[resolva]

I have tried following that exact guide but i seem to get a compile error when I click on the combo box.

Would love it if someone could have a look why it doesnt select it correctly.

Thank you

 

[ajetrumpet]

i would try to help, but it seems as the LINQ boy is beating to the punch as of now... I will look too, just because I started to help here to begin with..

 

[ajetrumpet]

Res,

My professional opinion is that you need to possibly hire someone to get you started on what you want to do. You are trying to change values in a bound from with a combo box. this is not ideal for building databases. Autofills are generally meant to be targeted at unbound controls, not bound ones. Just a suggestions...

 

[missinglinq]

For some reason, but in the code window, Access has added an underline character to the names of your textboxes, When you use the pulldown box in the code module, the names you see are

txtFirstName_
txtLastName_
txtTitle_

Don't know why Access did this.

In Design View, go into the Properties Sheet, delete the name of each of the textboxes, and re-enter them. Once I did this, everything worked ad expected.

 

[resolva]

missinglinq

I have looked at the end of all the textboxes and there arent any _. Maybe it is the version of access I am using?

Could you do me a huge favour and delete the _'s and reattach the database.

Would really help me out.

Kind regards,

Aaron

 

[unclejoe]

This the Perform Name AutoCorrect feature in Access.

You had renamed the controls, but in the process you left two spaces when you save the form. There are two underscores actually, not one as in missinglinq post.

For example, if you name your control as “First Name” with a space, Access will name it as “First_Name” with the underscore to replace it for the space.

You had renamed your control to “txtFirstName “ with two spaces accidentally but it will not be visible in the control’s properties field.

It will not be noticeable if you’re not an experience user. What you need to do is to rename it again. First, highlight the control name field in the property sheet, press delete key and press again one more time (more than one if necessary) than press the Backspace key a couple of times so as to clear any spaces.

missinglinq

I have looked at the end of all the textboxes and there arent any _. Maybe it is the version of access I am using?

Could you do me a huge favour and delete the _'s and reattach the database.

Would really help me out.

Kind regards,

Aaron

 

[marianne]

you want to automatically fill up a black field after you select certain record right?

your problem is not autofill. what i think you want and need is dlookup function.

you may want to study this attached file.

 

[resolva]

Thank you for that marianne,

I have attached a database file (basic) of what I am trying to do.

Your see in the Ingredient table there is IngredientName and Concentration.

Then in the Recipe Form there is the recipe information and then the check box and then a concentration box.

I basically want to be able to pick a ingredient and then automatically pull the concentration over with it and fill the concentration box? Could it be done with a query?