newbie question: data from one table on two forms

[George]

I'm creating a relatively simply movie DB which so far has one table with
all of the data and two forms. (I want to have everything done in forms so
it appears like an app and other people can use it with a simple interface)

The second form has only a text box with a lot of information and is
naturally of the memo type. When i'm going through the records on form1 and
click a cmd button, i want to be able to display the contents of the record
i am currently on. The problem i have is, the second form pops up and the
info in the field starts from the first record in the table and is not
"keeping up" with the actual record i'm on.

I'm not sure if this is clear. Let's say the table has only three
fields."Title", "year relased" and "other junk"
Form1 has boxes for title and year released. The cmd button opens up form2
and should display "other junk" for the same record.

I'd also like to hide the record selector in the second form as
I don't want to be able browse through the data on form2, only display the
info related to the same record. (movie)

I figure i might have to use filters, another data source in the table, VBA,
all of the above?
Just not sure how to go about it or how to code it.

 

[Larry Daugherty]

Hi George,

It's easier than you might think. Make sure your wizards are enabled on the
Toolbox (wand and stars). Copy your existing form and then put the copy in
design mode. Delete the command button to show the record details. Click
the command button in the toolbox and draw it in again. The wizard will pop
up. Tell it you want a form operation and pick your detail form. I think it
will help you the rest of the way.

Record selectors, navigation buttons, etc are simply a matter of putting the
form into design mode and working your way through the properties.

HTH

 

[Guest]

to get rid of the navigation buttons is very easy. You can leave the form in
form view you don't need design view but in form view it will still be active
so clicking a command button will perform it's task. Click on properties and
it will stay there now just left click on the form in different spots and you
will notice the properties will change depending on where you click. If you
click on the very left of the form the title of the properties will come up
Form go to the 'format' tab or 'all' tab and look for navigation buttons
change it to no and they go away. The same goes for record selectors and
dividing lines.

As for the rest of what you want I'd say it would be a matter of adding a
where statement into the command button in vb
" where [Title] = Forms!formname.nameoftextbox/listbox.value"
that would look up what you have clicked on in your textbox/listbox and only
display the rows of your table with that value in the Title column
substitue formname with your form name with the textbox/listbox
substitute nameoftextbox/listbox with the name of the text box or list box
something along those lines anyway