Command buttton doesn't find fields in parent form

A

AccessComp

When i try to link a form to a main form using a command button it only shows
the fields in the form I'm trying to link to and no fields in the main form.
I am using referential integrity (which works great). What am I doing wrong?
 
K

KARL DEWEY

Where is the 'command button' located that you are using to try and link form
to a main form?
 
K

KARL DEWEY

Ok, talk me through it. What does the command button call? An event, if so
then what is the code? A macro, if so then what actions?
I am not following you thought process but maybe it is because I do not have
knowledge of stuff in the middle.

I can not relate a command button to linking fields in forms.
 
A

AccessComp

What I'm trying to do is instead of using a subform, I want to use a command
button to bring up a form to display selected data. for example I have made a
form called "Credits" that I want linked to my recordings form so that I can
add and display info i.e. Bass player, Drummer, Producer for the album, go to
my next recording and input indo about that cd on the same form. What is
going on is when I select the "show records to display option it only shows
the fields on the "Credits" form and nothing on the Recordings form which is
on the left side. The button is being placed on the recordings form. Since
there's nothing on the left side, I can't press the <-> button. It keeps
telling me I have to select something from the left side and there's nothing
there.
 
K

KARL DEWEY

Where you place a button has nothing to do with the action it is to perform!
I asked --- What does the command button call? An event, if so then what is
the code? A macro, if so then what actions?
 
A

AccessComp

It's a Macro it's an openForm statement. Arguments are: Credits,
Form,,"[RecordingID]=" & [RecordingID],,Normal
Hope this helps
 
K

KARL DEWEY

What condition is this --- ,,"[RecordingID]=" & [RecordingID],, that you have?
You are comparing RecordingID to what?

--
KARL DEWEY
Build a little - Test a little


AccessComp said:
It's a Macro it's an openForm statement. Arguments are: Credits,
Form,,"[RecordingID]=" & [RecordingID],,Normal
Hope this helps


KARL DEWEY said:
Where you place a button has nothing to do with the action it is to perform!
I asked --- What does the command button call? An event, if so then what is
the code? A macro, if so then what actions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top