record source prblems ((URGENT!!!!))

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

write i create a form in which data can be inputted and named it "data entry
form" i then created a query so i could select multiple fields from different
tables to be the record source . when i set my query as the record source and
then change to form view on my form it appears black but yet when yu change
back into design view every things thr on the form . i ave been havin this
problem for weks and still cant solve it .

The Qry tht i'm usin for the record source when i change it to data sheet
view i dont even get the emtpy record line with the add but i just get no
white boxs.

i really dont no wht to do any more ???

if you want a copy of the database or printscreens of relatioships just but
this is very urgent needs to be completeed by next week:(
 
Hi,
The query you are using is not updateable. You'll have to come up with a different approach to your
design.
 
On Sat, 9 Apr 2005 05:47:05 -0700, "Tom O" <Tom
write i create a form in which data can be inputted and named it "data entry
form" i then created a query so i could select multiple fields from different
tables to be the record source . when i set my query as the record source and
then change to form view on my form it appears black but yet when yu change
back into design view every things thr on the form . i ave been havin this
problem for weks and still cant solve it .

The Qry tht i'm usin for the record source when i change it to data sheet
view i dont even get the emtpy record line with the add but i just get no
white boxs.

i really dont no wht to do any more ???

if you want a copy of the database or printscreens of relatioships just but
this is very urgent needs to be completeed by next week:(
Click to expand...

Rather than creating One Great Master Query linking all your tables -
a query which will almost certainly contain no records and not be
updateable, as you are seeing - I'd suggest basing your Form on the
"one" side table, and put Subforms on it for the related tables.

If you'ld care to post a *text description* (not a picture, not a
database, but typed in text) of your tables and how they are related,
someone should be able to help set this up.

John W. Vinson[MVP]
 
Tom,

What you are trying to do is not hard. In fact, it is the way I set forms
up. Since you have the query built, put a parameter in the key field you
want to find records by. I usually use a combo box to get the key value, the
the query to return the record from the query, then code to put the values
from the fields into the controls, the code to add or update the tables that
need changes.
 
Hello,
Eager Young Minds of Today!
Recently, I have been through a good forum, hence I feel you to have a look
at it, and if you like, be a member, and discuss about Computer, Love,
Romance, Hacking, Cracking, Poems etc.

Site: http://www.devworld.tk

- Regards,
Jess.
 
Back
Top