Access - New record in non-linked subform

[cbenisch]

I have an access form that has a marco button to open another form using a filter that returns records in the new form that have a matching recordID field from the main form. This works fine.



I want to be able to add records to the table which works as well only the recordID field is not populated with the id field used in the filter from the main form. How can I populate the recordID field with that of the master filed from the main form? It is just blank on the new records created now.

I expect this is easy to resolve and I am just not seeing it.

Thanks in advance for any help.

[pbaldy]

You can set the default value property of the subform textbox to the one on the main form. That way new records will get the same ID.

[cbenisch]

I appreciate the quick response but that does not seem to resolve the issue.

[pbaldy]

Can you post the db with it not working?

[cbenisch]

I am still working with it now. It may be an issue with getting the control name entered correctly. Here is what I set the default to " =[Forms]![Facility Information]![txtFMLID] "

Here is result

[cbenisch]

I am not able to make this work. I cannot post the database in post to the forum because of the data it contains. Removing the data would be very time consuming.

I have a folow up question though. Is it possible to create a subform that opens in a new window rather than being part of the main form? If I have a liked subform it works fine but I would like it to open a new window rather than having it as link subform. I have several forms I want to open and add records to from the main form.

[pbaldy]

This works for me:

=[Forms]![frmTripSheetMain]![txtFromDate]

so make sure the form and control names are correct, and of course the form must be open. You can certainly create a form that opens on its own. It would no longer be a "subform", since at that point it would not be within another form.

[cbenisch]

Seems to be an issue with the main form being used in navigation form. If I open the main form directly it works. If I use the main form from the navigation form in 2010 it does not work.

[cbenisch]

Tried changing it to =[Forms]![Navigation Form]![NavigationSubform].[Form]![tbxFMLID] so that it is referncing the form in the Navigation form but that does not work either.

Thoughts?

[pbaldy]

Hard to say without seeing it. Have you tried the Build function from the default value property? That would let you navigate to it and let Access create the syntax.

[cbenisch]

That is what i did to get the syntax listed above.

[pbaldy]

Sorry, but I'm stumped. I haven't used the navigation form feature, so perhaps there's some quirk with it. If you get time to put together a sample to play with, I'll try to figure it out.

[cbenisch]

I pinged the MS office_2010-access forum about the navigation issue and found a thread wit what seems to be the same issue and there is no resolution yet. Here is the link

http://answers.microsoft.com/en-us/o...4-8bdf6852af13

Thanks for the help. May just have to bail on using the navaigation.

[cbenisch]

As to a sample I am guessing you could drop your existing form onto a navigation form and it would fail the same way. That is all I did to get to where I am now.

Thanks again for the time you did spend on this.