Display

[Amenofhis]

Hi, im new in this forum i dont know where should i put my question so i decide to do it in the general. if not here sorry.


I have a problem i dont know how to resolve i start using access and i doing a form i have all the tables set but i want to do a display i made a Combo box with some Codes those codes reprensent a Name. what i want to do is: if the person choose one of those codes the name appears of the code chosen

 

[vbaInet]

Create the combo box and place it at the HEADER SECTION of your form.

When the wizard appears select the Third option which reads, "Find a record on my form based on the value I selected in my Combo box"

Follow the instructions from there.

Welcome to the forum by the way.

 

[Amenofhis]

Create the combo box and place it at the HEADER SECTION of your form.

When the wizard appears select the Third option which reads, "Find a record on my form based on the value I selected in my Combo box"

Follow the instructions from there.

Welcome to the forum by the way.

------------------------------------------------------------------------------------------------
u mean if i chose a Serial Code from my combo box it will appear in another text box example view.


[-------] <---Combo box with codes

aside of that
a [______________________] text box that i want to appear whta u chose in the combo box, something like that, im not in my house right now i cant upload a pic i took

 

[vbaInet]

The record will appear on the form in those textboxes.

 

[Amenofhis]

Did what u told and i didnt got the wizard guy.. im using access 2007

 

[vbaInet]

The wizard is a woman

1. Did you put it in the Header section?
2. Is your form bound? It will not work if it's not bound. Bound means in the Record Source property there's a query or table selected.

 

[Amenofhis]

The wizard is a woman

1. Did you put it in the Header section?
2. Is your form bound? It will not work if it's not bound. Bound means in the Record Source property there's a query or table selected.

Yes is bound

yes i try a way and it appears the name but just once after using a related table option.. hum wait let me ulpload a pic so u have an idea

I uses a way to make the code appear things is it says somenthing about Duplicates but still nothing.

 

[Amenofhis]

Done, Sorry for the inconvenient i cause now i want to create something like that but for Querry Table therefore i need some advice from you THANKS THANKS VERY THANKS for your help, my issue was that my P.Key it was the code and it didnt accept duplicates thats why.

What i did is:
I put another More important table as my P.key because that table cant be repeated and i use a drad a existing field to my form then the Wizard appears and i related the name with the Code table. it works very good. Thanks in advantage of the knowledge u gave me.

 

[vbaInet]

I'm glad you figured it out.