Automatically complete entries in table ...

[fluppe]

hello,
i am not sure but i think this is a general question:

I have a Form with a Subform that displays a table/query. The form also contains a ComboBox to apply a filter.
Now it is possible to add a record to the displayed table, or better, the table from which my filter-query receives it's data, but i have to manually set the value for the field that the filter applies to. I want to auto-fill this field with the Value in the CBO elt. but i don't know a comfortable way to do so.

To make it more clear:

tbl1: Typ, Container

tbl2: Container

CBO has tbl2 as Datasource and the "filter" is a query that is altered via VBA code to "SELECT * FROM tbl1 where Container = (CBO.Text)"

There is a shorter table displayed, when the filter is applied, but if i add an element now, it is not assured that "Container" takes the value (CBO.Text). But i want to make that sure, so one doesn't need to add this information and to make sure (after using the filter) one can only add elts. to tbl1 with Container = (CBO.Text)....

.... is my problem clear ?



I'd appreciate any hint.

Kind regards,
...

[Z1nkstar]

Well I believe the best way would be to use VBA because what I am getting out of this is that you want to keep that value under CBO and your end users only have the ability to add etls Correct?

Okay well Can I get some screen shots?

[fluppe]

Hello again,

that Screenshot is a little big ... now a little small ...(edit: oh, no, it's allright), but it is nearly how i want it to be like. The CBO can be altered by the User, that is intended. In my example a longer list of things is filtered for the Garage in which they are stored ....


It seems to me that i have to go through the displayed entries and search for empty fields, but in the properties of my subfunction i only find enter and exit fcns that i can specify in VBA. That is my first problem, because i can not easily have sort of "Updated/Altered" - method, in which i could be sure there is only the last entry in my source table that may have empty entries and just set these according to the filter option.

So, i just don't know how to go ahead ... i do not even know how to loop through the table (which i would have to do i guess, to achieve what i intend in a "Exit" method.

greetings and thanks for your interest,

....

[Z1nkstar]

So are your end users actually editing the data in your tables?

[fluppe]

Yes, to some extent this can not be avoided ... this is an example for a somehow very direct way to do this. Another would be to have an "add_thing" button which opens a form where you can enter all the data ... but that would be not too comfortable as well, or ?

[Z1nkstar]

Well if a user changes deletes or removes record for the tables they are gone forever not saying you can trust people but accidents can happen.
What I would suggest just because its much more valuable in the long run would be to have a main form that has an edit form a main records form and other forms for searching and other form that are needed . . .
running through the forms is a much better way for your database to be secure . . I am saying you get way more edits and customization's to your data through the forms.

[fluppe]

Well, data deletion would be a problem indeed, and it is NOT intended so far.
So you suggest s.th. like the "add_entry" form, right ? Well, I'll do so.

Another question: Is there a way to export parts of a database as a new database ?

My DB will have a structure that consists of "editable" (extendable) tables and of some tables that cannot be altered by the user. It would be of great benefit, if one was able to export parts of those extendable tables along with the fixed tables as a new but smaller DB at some point.

I might make another thread from that ...


Kind regards, thanks for your advice so far and a nice weekend,

...

[Z1nkstar]

Exporting parts yes its possible but if you want the data to be the same you should make sure that the tables are linked

[fluppe]

Sorry i'm late.
Thanks for the help, i think i'll back when i am busy with exporting DBs, but I'll open a new thread for that.

So long,
...