Form Search *urgent*
anonymous_at_discussions.microsoft.com
Date: 04/06/04
- Next message: Kevin Sprinkel: "Calculating totals from a sub form to a main form"
- Previous message: Allie: "Calculating totals from a sub form to a main form"
- In reply to: Art: "Form Search *urgent*"
- Next in thread: Adrian Jansen: "Re: Form Search *urgent*"
- Reply: Adrian Jansen: "Re: Form Search *urgent*"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 6 Apr 2004 12:16:30 -0700
Thanks for you quick response! I can get a list of
everything in my key field, I guess my problem comes with
updating subsequent fields based on that field.
Like if I select "Customer", I want the address, phone,
email addresses to be based on that field I picked. I
can't figure out how to do that.
Thanks again!
>-----Original Message-----
>Hi Cimmy,
> A combo box on your form seems like the way to
>go. You could select a key value and the form would
update
>depending upon that value. Use the combo box wizard on
the
>toolbar and follow it along.
>
>Hope This Helps
>>-----Original Message-----
>>I'm pretty new to Access, and am using 2000. I have a
>>form that will update a specific field in my database.
>>
>>I have 500 records and want to be able to navigate to a
>>specific record based on a key value rather than having
>to
>>scroll through ALL of my records. How can I do this??
>>
>>Ideally, I'd like to select my key value and have all of
>>the fields populate based on that criteria.
>>
>>Thank you in advance.
>>.
>>
>.
>
- Next message: Kevin Sprinkel: "Calculating totals from a sub form to a main form"
- Previous message: Allie: "Calculating totals from a sub form to a main form"
- In reply to: Art: "Form Search *urgent*"
- Next in thread: Adrian Jansen: "Re: Form Search *urgent*"
- Reply: Adrian Jansen: "Re: Form Search *urgent*"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
