Need Help on this one....

[Gemini32]

Hi Folks


My work order is in Access and is looking quite well now with the assistance of the genious people on this board ...Thank you again....

Now I would like to do this ...Not sure if it is possible.....


When I enter the data for the customer ie: name , address, phone # etc.....


I would like to just enter the customer's name and have the address, along with the rest of the customer information come up automatically in the text box under the customer's name...

example of what I mean



Customer name Jabcob Icely

Address 123 Flying Street

Phone # 555-5555


Is this possible to do ...I'm just tweaking my work order to perform even better...


Thank you ahead of time for any help that is provided to me on this topic....

:D Gemini32 :D

 

[Corticus]

Hey Gemini,

This should be easy...

Easiest method- have a combobox for your customers name on your contact form, just insert a combobox, and use the wizard to have Access select a record based on what you put in the combobox.

If you need a textbox for the name, use code as follows:
TxtNameSch is where you type the name you want to find.
[name] represents the name field in your customer table.

Private Sub TxtNameSch_AfterUpdate()

Set rs = Me.Recordset.Clone
rs.FindFirst "[Name] = " & Str(Me![TxtNameSch])
Me.Bookmark = rs.Bookmark

End Sub

HTH,

 

[Gemini32]

Hi Corticus

I'm going to try this right now ...Thanks again...


I'm not good at all with this VB Code in access or other one for that matter....hahahaha...But I'm willing to learn....
Thanks Corticus...

:D Gemini32 :D