Programming a form question.

[Jon123]

I have a main form1 and I have a field called rework and this field is setup as a memo field on the table. I have a command button that when selected will open a second form (pop up) and there are 3 fields on this pop up form "date" "name" and "reason" and a command buttom on the pop up called update. Now what I want to do is once I click the command button to get the pop up and I enter the date , name, and the reason I want to click that update button and have those 3 fields update to the memo field on form1. I want it added to so for every time it's clicked it will add another line to that memo field. I have everything working except for the update button. Any help, can this even be done?

Thanks

Jon

 

[Jon123]

Sorry I should add that I can get 1 of the 3 fields to update I just can't figure out the code for all 3. Code is {forms![form1].memofield = (me.name) }

that will put the name in the meno field. I have tried AND with the other 2 fields but I won't work. I also can't get it to add to it. Every time it over writes it.

 

[plog]

So you want to treat your database as one big text document? Why? This is not the way it should work.

Distinct data values should be in their own field. It sounds like you need a whole new table to store this data--why not do that? Not only is it the proper way to store your data, its the path of least resistance--it's simple to set a form's datasource to a table instead of constantly appending bits of data to one field.

Again, rethink what you are doing--you're using a database, use it as a database.

 

[Jon123]

No that is not it entirely. But I do see your point. I just want to use 1 field on a tabular form to act like a simple post it note if you so that if the record set that they are currently looking at has had 1 or more reworks. If that makes sense. But I think I could add it to a table and then link it. Maybe like a sub form

 

[plog]

Yes, that's exactly how it should be done. That will give you the ability to search the notes more easily.

 

[Jon123]

Ok so I got my sub form setup and working. I have it setup as a continues form so it will show all the time someone has had to rework it. However it always has a blank record at the bottom. Can this be turned off? Can't find it

 

[plog]

First, that isn't technically a record--its a place for users to add a new record. If nothing gets typed in there, the record doesn't exist. How do you want them to add new data to that table? I'd just leave it as it is.

However, you can get rid of it-- on the subform you set the property that says something like 'Allow Additions'.