unbound subform (97 sr2)

Topic

New Reply

I’m sooo confused. I am trying to create a subform on a main form. Usually I just drag and drop it and it works beautifully. This time, though, there is something wrong with the master/child link. It says “can’t build a link between unbound forms.” I don’t think I’ve ever paid attention to bound/unbound forms.

What does that mean? What do I look for? How do I fix it?ahhhhh

Reply | Quote

Replies

It doesn’t mean what it says and you can safely ignore it. However, you’ll have to set your master and child links by typing in the field or control names rather than using the wizard. Take a look at MSKB Q168872 for more information.

It actually is possible to bind a subform to an unbound parent form, but in this case the message might also mean that Access can’t recognize any possible field name matches between the forms and you don’t have any relationships established that would give it a clue.

Reply | Quote

Charlotte,
Is there an Index for MSKB articles? Hopefully by topic – Access 97, Access 2000, etc. Typically when I use the Search box, my phrasing does not match what Microsoft wants.

Thank You
Jim

Reply | Quote

I wish! Actually, I ran across a site that did something like that, but I can’t remember where. I’ll try to track it down on post it if I can find it.

I usually look them up in TechNet and then search for the article number on-line in order to post the links. The search engine in the Microsoft support site is on a par with the help in Office 2000 and later–in a word, awful. I find it difficult to use and confusing … especially when I know the article is there and just can’t hit on the right combination of keywords to retrieve it.

Reply | Quote

Thanks Charlotte,
I too have a few terms for the Office 2000 Help, but will not/can not use them here. I’ll be waiting to see if you can find the “Indexed” site, hope you will be able to.

Jim

Reply | Quote

I’ve found http://www.freeanswers.com[/url%5D to be slightly more forgiving and certainly faster than the Microsoft support site. It’s not an index, it’s a search engine for the Knowledge Base.

Reply | Quote

Yeah, the freeanswers engine is far better than the MS support version. But I actually ran across something else. Darn, I wish I could locate that!

Reply | Quote

!! I found it: http://www.netfolk.co.uk/netfolk/access/articles/index.htm%5B/url%5D. I don’t know how up to date it is, but it should be helpful for 97.

Reply | Quote

Charlotte,
Thank You very much. Have looked around some on the Netfolk site and it seems as it can be very helpful.

Thanks again,
Jim

Reply | Quote

Hans,
Thanks, this looks as it will be a very helpful site. I have it bookmarked!!
Jim

Reply | Quote

See my other post for the link.

Reply | Quote

I found the answer I was looking for in this post – I was getting the message that I can’t link unbound forms. But I manually put in the field names and it seems to be working. I still have a question though. I usually put the ID field that I used to link on the form and the subform just to check that the same number shows up and it’s linking correctly. In this case the number shows up on the main form but the field stays blank on the subform. When I go look in the subform table, the number is there. It’s also in the subform when I open the subform directly. When I open the main form, all the information shows up in the subform correctly, with the correct main record, but the ID number doesn’t show up. Any idea why?

Reply | Quote

Are you sure there isn’t some kind of confusion over control names and control sources?

Otherwise, we’d have to see the database. If you wish, you can post a stripped down copy of your database. See post 401925 for instructions.

Reply | Quote

You could try setting the control of your subform to a query (whose ID = ID on Main Form), and requerying the subform through your main form’s OnCurrent event in VBA Code…something like

Private Sub MainForm On_Current()
Me!Subform.Requery

‘Or you can choose individual controls, whose record source is SQL code where ID = ID on main form

Me.Subform1.Form!ControlName.Requery

End Sub

Reply | Quote

I can’t figure this out. Maybe someone else can help so here is the database. The main table is NewMarketingList and the subtable is subtbleRegistrantInfo. The main form is Energy Conference Registration Form and the subform is sbformRegForm. Thank you.

Reply | Quote

RegistrantID IS displayed in the subform, but the subform on the main form is too narrow, hence the RegistrantID text box is cut off. Since the text box is right-aligned, you don’t see the RegistrantID.

Reply | Quote

okay, I’m an idiot!! Thank you!

Reply | Quote

…you beat me to it.

and , you’re not an idiot.

Reply | Quote

Thank you!

Reply | Quote

Reply | Quote