Right, I guess I was wondering if there was a way to reorder the operations. So that the data doesn't write to the table from the original form but from the edit form.
original form passes to edit form as text.
edit form passes to table as record data.
table records refresh original form.
@moke123 I followed your suggestion with the code
Set rst = CurrentDb.OpenRecordset(stTable, , dbAppendOnly)
rst.AddNew
rst(stFieldName) = NewData 'Add new data from combo box
rst("PublicationType_IDFK") = somevalue ' <<< add an...
Hope everyone had a happy labor day! Thanks for all the suggestions. I will post the final code once I work it out.
I still don't understand the hidden textbox though. I must be missing something. Yes, it's possible for a user to add garbage data to the database if they've filled out all the...
Thanks arnelgp!
I just tested that. I added a new record to the popup and closed it with the X. But it is actually adding the new record to the list of the main form and also to the table.
I understand that maybe "X" might be thought of as a way to escape out of the form and not add a record...
Hi Moke,
Thanks for the code. If the db has only simple tables, it looks like it would work well. So far I'm only getting compile errors or function errors with it though. There are probably two main underlying causes for this. 1) Unfortunately I have multiple dependent fields of various field...
I don't know. I think only ever understand up to 75% of what is happening with any given chunk of VBA code.
Everything seems to be working fine to my eyes using the adjusted code, without using an unbound text box.
I have no clue what syntax to try to get it to pass the text entered in the...
Thanks arnelgp!
I don't understand exactly.
It seems like the pop up record is being saved because it writes the record to the table. And also the main field of the new record passes from the popup back to the original form field. So I can see that it's been saved when the popup closes and...
You mean instead of OpenArgs:=NewData ? Are you talking about an unbound hidden text box, like I had in the first code I pasted?
I don't fully understand the unbound text box strategy for this particular case. I got that from someone else and it might have been useful in another scenario. It...
Hi Gina!
Yeah, it seemed to me like there was some unnecessary code in there too.
You're code is very helpful and does update the list. And it passes the entry from the edit form back to the original form!!!
The only thing it's not doing is passing the text entered on the original form to...
Hello!
I need some help reducing the number of clicks it takes to get to the center of the Access pop.
I am using an Edit List Form but find the user experience unsatisfactory. The ghosted button is difficult to see and the location is awkward. I also don't like that once I've entered the new...
Is it possible to do this as an Access function instead of VBA so I can store this in a table? Or should I not be storing the date in my table?
The end result I'm looking for is to have a form where I enter "press pitch info" and then select an appropriate holiday name from a combo box. Based...
I'm making a press release database which needs to track up coming holidays in order to set reminders. It's easy to enter fixed date holidays. But many of our holidays are on the second Sunday of a month or something like that. So the date changes year to year.
I don't know what the Access...