Table on a From

[dbmanalser84]

Hi. I have forms for each of my tables to enter data in tables. Can I and how, build a table on a same form where I'll be viewing all the data from that table that will be updated each time I enter a new data?

 

[DCrake]

Simple Software Solutions

Hi

Some answers are easily resolved if the question is stated clearly. It may be you know what you mean, but others need a little bit more detail. If you explain it from our point of view then a reponse will be made more efficiently and correctly.

 

[David Eagar]

It is better practise to base forms on queries rather than tables

 

[dbmanalser84]

Clarifying

Ok, Imagine that you have a form from where you enter data in one of the db tables, now you wan't to go somewhere beside the tables and queries to see all the data from that table in one place. So, can that data (from that table) be displayed (in table like manner) on that form? Was this clear enough? Thnx.

 

[twoplustwo]

List box? I think that's what you're after.

 

[dbmanalser84]

No..

List box? I think that's what you're after.

No thats not it, I want to display data not to enter, I have for entering. If you built Admin areas for Dynamic applicatins you know what I mean, a simple table that will show up on form and hold and show all the data (including those I enter) in it.

 

[twoplustwo]

Judging from your description you need something like this??

 

[dbmanalser84]

Yes

Exactly like that. The only difference I had in mind to do it in Tabular order not stacked if its possible. How do I do it?

 

[twoplustwo]

Turn the wizard on man - you can select the type of view i.e. DATASHEET etc.

 

[dbmanalser84]

Yes

Turn the wizard on man - you can select the type of view i.e. DATASHEET etc.

I tried that, man, and I got another form but only this time its tabular, but I don't want another form to enter data, I wan't a table just to view all the data. All the tables I created so far were displaying only one record (depending on which record page I was) I want, no matter on which record I am, to display all table results.

 

[twoplustwo]

I tried that, man, and I got another form but only this time its tabular, but I don't want another form to enter data, I wan't a table just to view all the data. All the tables I created so far were displaying only one record (depending on which record page I was) I want, no matter on which record I am, to display all table results.

Did this sound clear in your mind before you posted it?