Access 2007, Can we do this?

[Torturednacho]

Hi all I'm wondering if this is possible.

I haven't messed around with access in awhile. I'm trying to figure out if there is a way to do the following

Create a form with a single box. Have that box look in the "customer table" and pull up all the information in a sep. form?

I'm having a bit of a time with forms and stuff so any help would be appreciated.

 

[TheAceMan1]

How are ya Torturednacho . . .

How about a form in single display bound to the table, with an unbound combobox (say in the header, showing the names) that displays the selected customer/moves to that record. The [blue]combobox wizard[/blue] would do this for you!

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[MajP]

Although you could do the same thing prior to 2007 with some simple coding, 2007 now provides a Split Form natively.

http://office.microsoft.com/en-us/access-help/create-a-split-form-HA010075994.aspx

So you can have a continuous form on top (or bottom) and a single form on the bottom (or top). So you can scroll through all the records in the continuous form and see the details in the single form.

 

[Torturednacho]

So I decided to make a single form with buttons for now. However, I'm having an issue.

How would I query this.

IF Date=today (Or date entered) then Display = client and product?. I'm wondering if this would require perhaps some coding inside of the db. I guess I'm just looking for someone to point me in the right direction on this one.

 

[TheAceMan1]

Torturednacho . . .

We can do that, however we need some assemblence of your table structure. Tablenames, fieldnames, primary/foreign keys and datatypes, relaionships, and the formname.

You'll need the combobox to select the client and an unbound textbox for entering the date. These items will comprise your filter. And yes, there will be some code ... mainly for building the flter. It also sounds like you'll have a subform of products.

[blue]Your Thoughts? . . .[/blue]



See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]