By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,047 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Open Form B depending on the pk of Form A

P: n/a
Hello all

Form A (pk) & Form B (fk)

I want to display my Form B empty whenever is the first time, that the
pk form Form A, is enter. I click a button to open Form B. BUT if the
pk from Form A already exist, then show the information from that
record, when I open Form B. Basically have the option to create a new
record OR show existing information depending if the pk exist or its a
new one.

I know this can be done using subforms, but it wont work for me because
I have 17 forms that I need to relate. So I guess I cant put 17 forms
using subforms, I mean I can but it will be a complete mess, so I dont
want that.

Right now Form B is always showing the option to add a new record
(acFormAdd)

Can anybody help me here pleaseeeee

Jul 24 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
_17?

Really? Maybe your design is either (a) overly complex or (b) your
structure is not right. What is your database going to do? It just
sounds like this database is way more complicated than it should be.

Jul 24 '06 #2

P: n/a
Well yeah, for me it look complicated.

Its an interface call: Compressor Survey Application. It has 18 tables.
eg. compressors, cups, stages, cylinders,case parts assemblies,
gaskets, etc. Each table has in avg. 9-11 fields. This is the way it
works: Load the Location form, enter the location info, then click on
the compressor button. This compressor form uses the location_pk from
location form. Then you enter all the info in the compressor form and
click, stages. It takes you to the stages form, using the
compressor_pk. And so forth. You keep moving adding and adding
depending on your compressor. I can create multiple compressors for one
location, multiple stages for one compressor, multiple cylinders for
one stages....and so forth.

So I dont think the subforms will be a good idea for these. Thats why I
have created multiple forms, and interact b/w those form via buttons.
Right now everything is working fine, I only need that last thing.

Any ideas???

Thankss

Jul 24 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.