Form opens blank, is it corrupt?

[Sharky II]

Hi there

I had a button on a form 'a' that launched form 'b' with the correct customer ID of the customer from form 'a' - simple.

Deployed the DB in the office, it worked fine for a while but now the form just comes up blank (ie no text boxes etc, just the blue background).

I've tried deleting the button and adding it again but to no avail. The form 'b' will open correctly when double clicked in access from, the forms part of the object db screen thing in access.

Any ideas what it could be guys? I'm on XP (soon to downgrade to win2k as i get shoved out of this office ) and office2k.

Cheers

Eddie

 

[KenHigg]

What happens when you hit pageup/pagedown. Or when you hit tab/shift tab?

 

[Sharky II]

Hi ken

unfortunately, nothing happens. It doesn't even have the number of records in the little box in teh bottom left corner (you know, with the arrows to allow you to move between records etc) - that's blank.

But the form is 'there' and works if you double click it from the object viewer main screen?

Cheers

 

[KenHigg]

Cheap trick:

Do a new form and copy/paste all the stuff over...

 

[Mile-O]

If there is no record to display in the underlying recordsource then your form will be presented as completely blank.

 

[Sharky II]

If there is no record to display in the underlying recordsource then your form will be presented as completely blank.

hi mile-o-phile

i think this is the problem. i don't remember it being like this though. The idea is that you open this form to 'add a trip'. But it will only open if you already have a trip?! I never made it like that! It won't let me add a new trip either. You can view the old ones, but not click the little arrow star button [->] to add a new trip?! I know it USED to work as there are SOME records there!

Can't think why this would have happened, can anyone think of how to fix it? That would be greatly appreciated.

Many thanks

Edd

 

[Sharky II]

For example, i have a pretty much identical form for 'training courses' that works fine.

If you click on it it will show the form for training courses, and even if the customer has not been on any training courses, it allows you to add a fresh record (which has an autonumber which is set when you create a form, and also obviously has the customer ID of the customer).

If the customer has already been on a training course, you can still se those records in the form, and add a new one.

But the 'trip' one comes up BLANK *unless* the customer already has been on a trip (which must have been recorded when the form actually worked).

Hope this clarifies stuff, and that someone can help!

Cheers

Eddie

 

[KenHigg]

If there is no record to display in the underlying recordsource then your form will be presented as completely blank.

Do what???

 

[Sharky II]

it's true though, if i find a customer that has a been on a trip (which is wierd as you need to use the same form to ADD a trip), then i can see the form fine.

Grrrr.

 

[KenHigg]

Can you zip it down and post it?

 

[Sharky II]

Hi

I'd love to, but unfortunately it has about 2000 records and customer details in it, nothing important, but it'd be very naughty to send out their info over the net. It's also split into front end/back end.

I can zip up the front end and then you could see the code, but not any working records... i guess that wouldn't really help?

:S

Cheers

 

[KenHigg]

I'm confused. If I do a new table. Do a new form base on the table. When I open the form from a button on another form, It will not let me add a new record?

 

[Sharky II]

it should do. i just did a dummy one from scratch and it worked.

i have no idea why my 'big' 'proper' database won't work???

anyone any ideas? why it's suddenly changed? I think one of the db users fancies themselves as a bit of a know it all and messed up the db - i'm always fixing stuff they've broken. Gonna lock it this time.

Anyone?

Thanks

Eddie

 

[KenHigg]

My guess is that someone changed a property. Did you try my 'Cheap trick'?

 

[Sharky II]

just tried it mate. same thing happens

 

[KenHigg]

How exactly does form b know what record to try to display?

 

[Sharky II]

I use this code on the button:

Private Sub TrainingButton_Click()
On Error GoTo Err_TrainingButton_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "frmTrainingDetails"
    
    stLinkCriteria = "[CustomerID]=" & Me![CustomerID]
    DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_TrainingButton_Click:
    Exit Sub

Err_TrainingButton_Click:
    MsgBox Err.Description
    Resume Exit_TrainingButton_Click
    
End Sub

It just filters for the same customer ID as the current customer form.

 

[KenHigg]

This won't explain the error but, could you set up the record source for form 'b' to be a query in which you used the record id from form 'a' as a paramater.


??

 

[Sharky II]

SELECT tblTripDetail.*, tblTrips.*
FROM tblTrips INNER JOIN tblTripDetail ON tblTrips.TripID = tblTripDetail.TripID;

already is mate ^^^

 

[Sharky II]

oh right that's from TABLE B rather than form b.

how could i do that? And how come it works for the training one, and not the trip one, when they are afaik exactly the same?