Textbox values in form

[Booh]

Hello,
I have a problem with access 2003.

I have 1 table in my db. I created a form by using wizard, which shows data from that table. Then i added textbox in design view. And when i am changing value in one textbox, the values of all textboxes are changing automatically to the same value. Is it possible to turn off that?
Thanks!

PS. Sorry for my English.

 

[vbaInet]

If you're going to use one table then you're better off using Excel. Also, your database is not normalized and will not work properly. Read up on this:

http://r937.com/relational.html
http://support.microsoft.com/kb/100139

I suspect your form is set as Continuous view or Datasheet AND the textbox is unbound. This is the behaviour of an unbound control in one of those views. Check the CONTROL SOURCE property of the textbox and select a field from the list.

Welcome to the forum!

 

[Booh]

Thanks for the fast reply.

There are many tables in the db, in that example was only one
The form was set as Tabular. I thought that maybe it could be easier to add that unbound value field.

Now I created a db with 3 tables now, maybe you can see what's the problem with it.

Step by step how i created it:
1. I created 2 tables - Object and Document. Object can have many documents (a list of them), so i created a 3rd table - Connection.

2. I created a query with all the fields in all tables (don't need all of them actually)

3. Created tabular Form using query and deleted fields that i don't need.

4. The thing what i would like to have is only 1 row for each object and a list of documents related to object in combobox.

The picture of db:
bildites.lv/images/px2qqm8gghfd4jd3loi7.jpg
(cannot post links or pictures now, so please add www)

I think that the problem is something like:
1) Something wrong with the relations
2) I should add to combobox Row Source something like "WHERE Object_ID=Forms!Form1!Object_id_Number" (have tried many variation, but no luck)
Any suggestions?

Thanks

 

[vbaInet]

Naturally in a continuous form it's not possible. But look at this site from LPurvis and download Continuous Form Combo.

http://www.databasedevelopment.co.uk/examples.htm

I would urge you not to use Object, Connection and Document as names. You should change them.

NB: I noticed you're from Latvia right?

 

[Booh]

I think it's just what i needed.
Thank You very much!

Yes, those table names were just for an example.
And yes, I'm from Latvia

 

[vbaInet]

Good to know!

Alright, as long as it doesn't clash with Access reserved keywords you should be fine.

Ah, I've been to Riga. Lido restaurant has good food

 

[Booh]

Hope you enjoyed night life in Riga too
I have been last summer to UK too, nice country and many places to see and things to do at holidays.

 

[vbaInet]

Of course I was in Essence I think it was called.

Glad you enjoyed it here. Anyway, I hope the link has solved your problem.